-----
-- View: DBA_LOGSTDBY_UNSUPPORTED_TABLE
-- Purpose: Lists tables unsupported for Logical Standby
-----
TTITLE 'Tables Unsupported for Logical Standby|(from DBA_LOGSTDBY_UNSUPPORTED_TABLE)'
COL owner FORMAT A20 HEADING 'Schema Owner'
COL table_name FORMAT A30 HEADING 'Table Name'
SELECT
owner
,table_name
FROM dba_logstdby_unsupported_table
ORDER BY owner, table_name
;
TTITLE OFF

-----
-- View: DBA_LOGSTDBY_UNSUPPORTED
-- Purpose: Lists tables unsupported for Logical Standby because at least one column
-- has an unsupported datatype
-----
TTITLE 'Tables Unsupported for Logical Standby|Because of Columns With Unsupported Datatypes|(from DBA_LOGSTDBY_UNSUPPORTED)'
COL owner FORMAT A12 HEADING 'Schema Owner'
COL table_name FORMAT A24 HEADING 'Table Name'
COL column_name FORMAT A30 HEADING 'Column Name'
COL data_type FORMAT A20 HEADING 'Data Type' WRAP
COL attributes FORMAT A30 HEADING 'Attributes' WRAP
SELECT
owner
,table_name
,column_name
,data_type
,attributes
FROM dba_logstdby_unsupported
ORDER BY owner, table_name, column_name
;
TTITLE OFF