CHANGE_TABLES

CHANGE_TABLES describes existing change tables. The user must have the SELECT_CATALOG_ROLE privilege to access this view. This view is intended for use by Change Data Capture publishers.

Column	Datatype	NULL	Description
`CHANGE_TABLE_SCHEMA`	`VARCHAR2(30)`	`NOT NULL`	Change table owner
`CHANGE_TABLE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Change table name
`CHANGE_SET_NAME`	`VARCHAR2(30)`	`NOT NULL`	The change set this table belongs to
`SOURCE_SCHEMA_NAME`	`VARCHAR2(30)`	`NOT NULL`	The table owner in the source system
`SOURCE_TABLE_NAME`	`VARCHAR2(30)`	`NOT NULL`	The name of the corresponding table in the source system
`CREATED`	`DATE`	`NOT NULL`	Date on which this change table was created
`CREATED_SCN`	`NUMBER`		System change number (SCN) when this table was created
`CAPTURED_VALUES`	`VARCHAR2(1)`	`NOT NULL`	Indicates the values `O` (old), `N` (new), or `B` (both)
`PUB_ID`	`NUMBER`	`NOT NULL`	Publication ID for subscribers