VIEW: SYS.ALL_STREAMS_COLUMNS

Source

View Text - Preformatted

select s."OWNER",s."TABLE_NAME",s."COLUMN_NAME",s."SYNC_CAPTURE_VERSION",s."SYNC_CAPTURE_REASON",s."APPLY_VERSION",s."APPLY_REASON" from dba_streams_columns 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."COLUMN_NAME"
, S."SYNC_CAPTURE_VERSION"
, S."SYNC_CAPTURE_REASON"
, S."APPLY_VERSION"
, S."APPLY_REASON"
FROM DBA_STREAMS_COLUMNS S
, ALL_OBJECTS A
WHERE S.OWNER = A.OWNER
AND S.TABLE_NAME = A.OBJECT_NAME
AND A.OBJECT_TYPE = 'TABLE'