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 |
Change set to which this change table belongs |
SOURCE_SCHEMA_NAME |
VARCHAR2(30) |
NOT NULL |
Source table owner |
SOURCE_TABLE_NAME |
VARCHAR2(30) |
NOT NULL |
Source table name |
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 |