Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-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
Feedback

Go to previous page Go to next page
View PDF

CHANGE_TABLES

CHANGE_TABLES enables publishers to see existing change tables. You must have the SELECT_CATALOG_ROLE privilege to access this view.

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

The system commit SCN when this table was created

CAPTURED_VALUES

VARCHAR2(1)

NOT NULL

Indicates the values O (old), N (new), or B (both)