2.41 ALL_APPLY_KEY_COLUMNS

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

Related View

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

Column Datatype NULL Description

OBJECT_OWNER

VARCHAR2(128)

NOT NULL

Owner of the object on which substitute key columns are set

OBJECT_NAME

VARCHAR2(128)

NOT NULL

Name of the object on which substitute key columns are set

COLUMN_NAME

VARCHAR2(128)

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: