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

ALL_APPLY_KEY_COLUMNS

ALL_APPLY_KEY_COLUMNS displays information about substitute key columns for the tables accessible to the current user. Substitute key columns are set using the SET_KEY_COLUMNS procedure in the DBMS_APPLY_ADM package.

Related View

DBA_APPLY_KEY_COLUMNS displays information about substitute key columns for all tables in the database.

Column Datatype NULL Description

OBJECT_OWNER

VARCHAR2(30)

NOT NULL

Owner of the object on which substitute key columns are set

OBJECT_NAME

VARCHAR2(30)

NOT NULL

Name of the object on which substitute key columns are set

COLUMN_NAME

VARCHAR2(30)

NOT NULL

Column name of a column specified as a substitute key column

APPLY_DATABASE_LINK

VARCHAR2(128)

Database link to which changes are applied. If null, then changes are applied to the local database.

See Also:

"DBA_APPLY_KEY_COLUMNS"