Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-02
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
View PDF

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 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