[Home] [Help]
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'
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'
|
|
|
|