VIEW: SYS._DBA_STREAMS_NEWLY_SUPTED_11_1

Source

View Text - Preformatted

select owner, table_name, reason, '11.1', 111
    from "_DBA_STREAMS_UNSUPPORTED_10_2" o
    where not exists
      (select 1 from "_DBA_STREAMS_UNSUPPORTED_11_1" i
         where i.owner = o.owner
           and i.table_name = o.table_name)

View Text - HTML Formatted

SELECT OWNER
, TABLE_NAME
, REASON
, '11.1'
, 111
FROM "_DBA_STREAMS_UNSUPPORTED_10_2" O
WHERE NOT EXISTS (SELECT 1
FROM "_DBA_STREAMS_UNSUPPORTED_11_1" I
WHERE I.OWNER = O.OWNER
AND I.TABLE_NAME = O.TABLE_NAME)