ALL_REPKEY_COLUMNS

Describes the replication key column(s) accessible to the current user in each table.

The replication key column(s) is an alternate column or group of columns, instead of the primary key, used to determine which columns of a table to compare when using row-level replication. You can set the replication key columns using the SET_COLUMNS procedure in the DBMS_REPCAT package.

The following types of columns cannot be replication key columns:

• LOB or LOB attribute of a column object

• Collection or collection attribute of a column object

• REF

• An entire column object

  See Also: "SET_COLUMNS Procedure"

Related Views:

• DBA_REPKEY_COLUMNS describes the replication key column(s) in each table in the database.

• USER_REPKEY_COLUMNS describes the replication key column(s) in each table owned by the current user.

  Column	Datatype	NULL	Description
  SNAME	VARCHAR2(30)	NOT NULL	Owner of the replicated table.
  ONAME	VARCHAR2(30)	NOT NULL	Name of the replicated table.
  COL	VARCHAR2(4000)		Replication key column(s) in the table.