[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