DBA Data[Home] [Help]

VIEW: SYS.ALL_STREAMS_NEWLY_SUPPORTED

Source

View Text - Preformatted

select s."OWNER",s."TABLE_NAME",s."REASON",s."COMPATIBLE" from dba_streams_newly_supported s, all_objects a
    where s.owner = a.owner
      and s.table_name = a.object_name
      and a.object_type = 'TABLE'
View Text - HTML Formatted

SELECT S."OWNER"
, S."TABLE_NAME"
, S."REASON"
, S."COMPATIBLE"
FROM DBA_STREAMS_NEWLY_SUPPORTED S
, ALL_OBJECTS A
WHERE S.OWNER = A.OWNER
AND S.TABLE_NAME = A.OBJECT_NAME
AND A.OBJECT_TYPE = 'TABLE'