VIEW: SYS.DBA_STREAMS_NEWLY_SUPPORTED

Source

View Text - Preformatted

select owner, table_name, reason, compatible
    from (select * from "_DBA_STREAMS_NEWLY_SUPTED_10_1"
          where str_compat <= dbms_logrep_util.get_str_compat() union
          select * from "_DBA_STREAMS_NEWLY_SUPTED_10_2"
          where str_compat <= dbms_logrep_util.get_str_compat() union
          select * from "_DBA_STREAMS_NEWLY_SUPTED_11_1"
          where str_compat <= dbms_logrep_util.get_str_compat() union
          select * from "_DBA_STREAMS_NEWLY_SUPTED_11_2"
          where str_compat <= dbms_logrep_util.get_str_compat() union
          select * from "_DBA_STREAMS_NEWLY_SUPTED_12_1"
          where str_compat <= dbms_logrep_util.get_str_compat())

View Text - HTML Formatted

SELECT OWNER
, TABLE_NAME
, REASON
, COMPATIBLE
FROM (SELECT *
FROM "_DBA_STREAMS_NEWLY_SUPTED_10_1"
WHERE STR_COMPAT <= DBMS_LOGREP_UTIL.GET_STR_COMPAT() UNION SELECT *
FROM "_DBA_STREAMS_NEWLY_SUPTED_10_2"
WHERE STR_COMPAT <= DBMS_LOGREP_UTIL.GET_STR_COMPAT() UNION SELECT *
FROM "_DBA_STREAMS_NEWLY_SUPTED_11_1"
WHERE STR_COMPAT <= DBMS_LOGREP_UTIL.GET_STR_COMPAT() UNION SELECT *
FROM "_DBA_STREAMS_NEWLY_SUPTED_11_2"
WHERE STR_COMPAT <= DBMS_LOGREP_UTIL.GET_STR_COMPAT() UNION SELECT *
FROM "_DBA_STREAMS_NEWLY_SUPTED_12_1"
WHERE STR_COMPAT <= DBMS_LOGREP_UTIL.GET_STR_COMPAT())