Skip Headers

Oracle® Database Reference
10g Release 1 (10.1)

Part Number B10755-01
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
Feedback

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