Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_REPCAT.SET_COLUMNS

Purpose

To use an alternate column or group of columns, instead of the primary key, to determine which columns to compare when using row-level replication. You must call this procedure from the master definition site. For additional information, refer to

Syntax

The parameters for the SET_COLUMNS procedure are described in Table 12 - 167, and the exceptions are listed in Table 12 - 168. The syntax for this procedure is shown below:

DBMS_REPCAT.SET_COLUMNS(
	sname 		IN 	VARCHAR2,
	oname 		IN 	VARCHAR2,
	column_list 	IN 	VARCHAR2 |
	column_table	IN	DBMS_UTILITY.NAME_ARRAY)

Parameter Description
sname The schema in which the table is located.
oname The name of the table for which you will generate replication support.
column_list A comma-separated list of the columns in the table that you want to use as a "primary key". There must be no whitespace between entries.
column_table Instead of a list, you can use a PL/SQL table of type DBMS_UTILITY.NAME_ARRAY to contain the column names. The first column name should be at offset 1, the second at offset 2, and so on.

Table 12 - 167. Parameters for SET_COLUMNS

Exception Description
nonmasterdef The invocation site is not the master definition site.
missingobject The given object does not exist as a table in the given schema awaiting row-level replication information.
missingcolumn At least one column is not in the table

Table 12 - 168. Exceptions for SET_COLUMNS

Parameter	Description
`sname`	The schema in which the table is located.
`oname`	The name of the table for which you will generate replication support.
`column_list`	A comma-separated list of the columns in the table that you want to use as a "primary key". There must be no whitespace between entries.
`column_table`	Instead of a list, you can use a PL/SQL table of type DBMS_UTILITY.NAME_ARRAY to contain the column names. The first column name should be at offset 1, the second at offset 2, and so on.

Exception	Description
nonmasterdef	The invocation site is not the master definition site.
missingobject	The given object does not exist as a table in the given schema awaiting row-level replication information.
missingcolumn	At least one column is not in the table