ALL_CHANGE_TABLES

ALL_CHANGE_TABLES displays information about Change Data Capture change tables.

Column	Datatype	NULL	Description
`CHANGE_TABLE_SCHEMA`	`VARCHAR2(30)`	`NOT NULL`	Owner of the change table
`CHANGE_TABLE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the change table
`CHANGE_SET_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the change set to which the change table belongs
`SOURCE_SCHEMA_NAME`	`VARCHAR2(30)`	`NOT NULL`	Owner of the source table for the change table
`SOURCE_TABLE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the source table for the change table
`CREATED`	`DATE`	`NOT NULL`	Creation date of the change table
`CREATED_SCN`	`NUMBER`		Creation SCN of the change table
`CAPTURED_VALUES`	`VARCHAR2(1)`	`NOT NULL`	Indicates whether old (`O`), new (`N`), or both (`B`) update values are captured
`PUB_ID`	`NUMBER`	`NOT NULL`	Publication ID displayed to users for the change table