DBA Data[Home] [Help]

VIEW: SYS.ALL_CHANGE_TABLES

Source

View Text - Preformatted

SELECT
   s.change_table_schema, s.change_table_name, s.change_set_name,
   s.source_schema_name, s.source_table_name, s.created, s.created_scn,
   s.captured_values, s.obj#
  FROM sys.cdc_change_tables$ s
View Text - HTML Formatted

SELECT S.CHANGE_TABLE_SCHEMA
, S.CHANGE_TABLE_NAME
, S.CHANGE_SET_NAME
, S.SOURCE_SCHEMA_NAME
, S.SOURCE_TABLE_NAME
, S.CREATED
, S.CREATED_SCN
, S.CAPTURED_VALUES
, S.OBJ#
FROM SYS.CDC_CHANGE_TABLES$ S