Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_REPCAT.MAKE_COLUMN_GROUP

Purpose

To create a new column group with one or more members. You must call this procedure from the master definition site. For additional information, refer to

Syntax

The parameters for the MAKE_COLUMN_GROUP procedure are described in Table 12 - 149, and the exceptions are listed in Table 12 - 150. The syntax for this procedure is shown below:

DBMS_REPCAT.MAKE_COLUMN_GROUP(	
		sname				IN	VARCHAR2,
		oname				IN	VARCHAR2,
		column_group			IN	VARCHAR2,
		list_of_column_names		IN	VARCHAR2)

Parameter Description
sname The schema in which the replicated table is located.
oname The name of the replicated table for which you are creating a new column group.
column_group The name that you want assigned to the column group that you are creating.
list_of_column_names The names of the columns that you are grouping. This can either be a comma-separated list or a PL/SQL table of column names. The PL/SQL table must be of type dbms_repcat.varchar2s. Use the single value `*' to create a column group that contains all of the columns in your table.

Table 12 - 149. Parameters for MAKE_COLUMN_GROUP

Exception Description
nonmasterdef The invocation site is not the masterdef site.
duplicategroup The given column group already exists for the table.
missingobject The given table does not exist.
missingcolumn The given column does not exist in the designated table.
duplicatecolumn The given column is already a member of another column group.

Table 12 - 150. Exceptions for MAKE_COLUMN_GROUP

Parameter	Description
`sname`	The schema in which the replicated table is located.
`oname`	The name of the replicated table for which you are creating a new column group.
`column_group`	The name that you want assigned to the column group that you are creating.
`list_of_column_names`	The names of the columns that you are grouping. This can either be a comma-separated list or a PL/SQL table of column names. The PL/SQL table must be of type dbms_repcat.varchar2s. Use the single value `*' to create a column group that contains all of the columns in your table.

Exception	Description
nonmasterdef	The invocation site is not the masterdef site.
duplicategroup	The given column group already exists for the table.
missingobject	The given table does not exist.
missingcolumn	The given column does not exist in the designated table.
duplicatecolumn	The given column is already a member of another column group.