Oracle9i Database Reference
Release 1 (9.0.1)

Part Number A90190-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Static Data Dictionary Views, 130 of 521


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 

VARCAHR2(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) 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback