VIEW: SYS.DBA_STREAMS_UNSUPPORTED

Source

View Text - Preformatted

select owner, table_name table_name, reason, auto_filtered
   from (select * from "_DBA_STREAMS_UNSUPPORTED_9_2"
         where compatible = dbms_logrep_util.get_str_compat() union
         select * from "_DBA_STREAMS_UNSUPPORTED_10_1"
         where compatible = dbms_logrep_util.get_str_compat() union
         select * from "_DBA_STREAMS_UNSUPPORTED_10_2"
         where compatible = dbms_logrep_util.get_str_compat() union
         select * from "_DBA_STREAMS_UNSUPPORTED_11_1"
         where compatible = dbms_logrep_util.get_str_compat() union
         select * from "_DBA_STREAMS_UNSUPPORTED_11_2"
         where compatible = dbms_logrep_util.get_str_compat() union
         select * from "_DBA_STREAMS_UNSUPPORTED_12_1"
         where compatible = dbms_logrep_util.get_str_compat())

View Text - HTML Formatted

SELECT OWNER
, TABLE_NAME TABLE_NAME
, REASON
, AUTO_FILTERED
FROM (SELECT *
FROM "_DBA_STREAMS_UNSUPPORTED_9_2"
WHERE COMPATIBLE = DBMS_LOGREP_UTIL.GET_STR_COMPAT() UNION SELECT *
FROM "_DBA_STREAMS_UNSUPPORTED_10_1"
WHERE COMPATIBLE = DBMS_LOGREP_UTIL.GET_STR_COMPAT() UNION SELECT *
FROM "_DBA_STREAMS_UNSUPPORTED_10_2"
WHERE COMPATIBLE = DBMS_LOGREP_UTIL.GET_STR_COMPAT() UNION SELECT *
FROM "_DBA_STREAMS_UNSUPPORTED_11_1"
WHERE COMPATIBLE = DBMS_LOGREP_UTIL.GET_STR_COMPAT() UNION SELECT *
FROM "_DBA_STREAMS_UNSUPPORTED_11_2"
WHERE COMPATIBLE = DBMS_LOGREP_UTIL.GET_STR_COMPAT() UNION SELECT *
FROM "_DBA_STREAMS_UNSUPPORTED_12_1"
WHERE COMPATIBLE = DBMS_LOGREP_UTIL.GET_STR_COMPAT())