[Home] [Help] [Dependency Information]
Object Name: | ALL_CHANGE_TABLES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Change Data Capture change tables
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CHANGE_TABLE_SCHEMA | VARCHAR2 | (128) | Yes | Owner of the change table |
CHANGE_TABLE_NAME | VARCHAR2 | (128) | Yes | Name of the change table |
CHANGE_SET_NAME | VARCHAR2 | (128) | Yes | Change set to which change table belongs |
SOURCE_SCHEMA_NAME | VARCHAR2 | (128) | Yes | Owner of the source table for the change table |
SOURCE_TABLE_NAME | VARCHAR2 | (128) | Yes | Name of the source table for the change table |
CREATED | DATE | Yes | Creation date of the change table | |
CREATED_SCN | NUMBER | Creation SCN of the change table | ||
CAPTURED_VALUES | CHAR | (1) | Yes | Indicates whether OLD, NEW or BOTH update values are captured |
PUB_ID | NUMBER | Yes | Publication ID displayed to subscribers for the change table |
Cut, paste (and edit) the following text to query this object:
SELECT CHANGE_TABLE_SCHEMA
, CHANGE_TABLE_NAME
, CHANGE_SET_NAME
, SOURCE_SCHEMA_NAME
, SOURCE_TABLE_NAME
, CREATED
, CREATED_SCN
, CAPTURED_VALUES
, PUB_ID
FROM SYS.ALL_CHANGE_TABLES;
|
|
|