VIEW: SYS.DBA_SOURCE_TABLES

Source

View Text - Preformatted

SELECT DISTINCT
   s.source_schema_name, s.source_table_name
  FROM sys.cdc_change_tables$ s, dba_tables t
  WHERE s.change_table_schema=t.owner AND
        s.change_table_name=t.table_name

View Text - HTML Formatted

SELECT DISTINCT S.SOURCE_SCHEMA_NAME
, S.SOURCE_TABLE_NAME
FROM SYS.CDC_CHANGE_TABLES$ S
, DBA_TABLES T
WHERE S.CHANGE_TABLE_SCHEMA=T.OWNER AND S.CHANGE_TABLE_NAME=T.TABLE_NAME