Oracle® Database Advanced Replication Management API Reference 10g Release 1 (10.1) Part Number B10733-01 |
|
|
View PDF |
This procedure enables you to use an alternate column or group of columns, instead of the primary key, to determine which columns of a table to compare when using row-level replication. You must call this procedure from the master definition site.
When you use column objects, if an attribute of a column object can be used as a primary key or part of a primary key, then the attribute can be part of an alternate key column. For example, if a column object named cust_address
has street_address
as a VARCHAR2
attribute, then you can specify cust_address.street_address
for the column_list
parameter or as part of the column_table
parameter. However, the entire column object, cust_address
, cannot be specified.
For the storage table of a nested table column, this procedure accepts the NESTED_TABLE_ID
as an alternate key column.
When you use object tables, you cannot specify alternate key columns. If the object identifier (OID) is system-generated for an object table, then Oracle uses the OID column in the object table as the key for the object table. If the OID is user-defined for an object table, then Oracle uses the primary key in the object table as the key.
The following types of columns cannot be alternate key columns:
REF
See Also:
The constraint_clause in Oracle Database SQL Reference for more information about restrictions on primary key columns |
DBMS_REPCAT.SET_COLUMNS ( sname IN VARCHAR2, oname IN VARCHAR2, { column_list IN VARCHAR2 | column_table IN DBMS_UTILITY.NAME_ARRAY | DBMS_UTILITY.LNAME_ARRAY } );
Note: This procedure is overloaded. The |