Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_REPCAT.DEFINE_COLUMN_GROUP

Purpose

To create an empty column group. You must call this procedure from the master definition site. For additional information, refer to

Syntax

The parameters for the DEFINE_COLUMN_GROUP procedure are described in Table 12 - 109, and the exceptions are listed in Table 12 - 110. The syntax for this procedure is shown below:

DBMS_REPCAT.DEFINE_COLUMN_GROUP(	
			sname		IN	VARCHAR2,
			oname		IN	VARCHAR2,
			column_group	IN	VARCHAR2,
			comment	IN	VARCHAR2 := NULL)

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 column group.
column_group The name of the column group that you want to create.
comment This user text is displayed in the RepColumnGroup view.

Table 12 - 109. Parameters for DEFINE_COLUMN_GROUP

Exception Description
nonmasterdef The invocation site is not the masterdef site.
missingobject The given table does not exist.
duplicategroup The given column group already exists for the table.

Table 12 - 110. Exceptions for DEFINE_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 column group.
`column_group`	The name of the column group that you want to create.
`comment`	This user text is displayed in the RepColumnGroup view.

Exception	Description
nonmasterdef	The invocation site is not the masterdef site.
missingobject	The given table does not exist.
duplicategroup	The given column group already exists for the table.