VIEW: SYS.USER_SOURCE_TABLES

Source

View Text - Preformatted

SELECT DISTINCT
   s.source_schema_name, s.source_table_name
  FROM sys.cdc_change_tables$ s, all_tables t, sys.user$ u
  WHERE s.change_table_schema=t.owner AND
        s.change_table_name=t.table_name AND
        s.change_table_schema = u.name AND
        u.user# = userenv('SCHEMAID')

View Text - HTML Formatted

SELECT DISTINCT S.SOURCE_SCHEMA_NAME
, S.SOURCE_TABLE_NAME
FROM SYS.CDC_CHANGE_TABLES$ S
, ALL_TABLES T
, SYS.USER$ U
WHERE S.CHANGE_TABLE_SCHEMA=T.OWNER AND S.CHANGE_TABLE_NAME=T.TABLE_NAME AND S.CHANGE_TABLE_SCHEMA = U.NAME AND U.USER# = USERENV('SCHEMAID')