Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-01
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, 166 of 625


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)


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996, 2002 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