DBA Data[Home] [Help]

VIEW: SYS.ALL_STREAMS_UNSUPPORTED

Source

View Text - Preformatted

select s."OWNER",s."TABLE_NAME",s."REASON",s."AUTO_FILTERED" from DBA_STREAMS_UNSUPPORTED 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."AUTO_FILTERED"
FROM DBA_STREAMS_UNSUPPORTED S
, ALL_OBJECTS A
WHERE S.OWNER = A.OWNER
AND S.TABLE_NAME = A.OBJECT_NAME
AND A.OBJECT_TYPE = 'TABLE'