Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-08
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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