Static Data Dictionary Views, 7 of 666

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"