Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_REPCAT.DROP_COLUMN_GROUP

Purpose

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

Syntax

The parameters for the DROP_COLUMN_GROUP procedure are described in Table 12 - 117, and the exceptions are listed in Table 12 - 118. The syntax for this procedure is shown below:

DBMS_REPCAT.DROP_COLUMN_GROUP(	sname		IN	VARCHAR2,
					oname		IN	VARCHAR2,
					column_group	IN	VARCHAR2)

Parameter Description
sname The schema in which the replicated table is located.
oname The name of the replicated table whose column group you are dropping.
column_group The name of the column group that you want to drop.

Table 12 - 117. Parameters for DROP_COLUMN_GROUP

Exception Description
nonmasterdef The invocation site is not the masterdef site.
referenced The given column group is being used in conflict detection and resolution.
missingobject The given table does not exist.
missinggroup The given column group does not exist.
missingschema The given schema does not exist.

Table 12 - 118. Exceptions for DROP_COLUMN_GROUP

Parameter	Description
`sname`	The schema in which the replicated table is located.
`oname`	The name of the replicated table whose column group you are dropping.
`column_group`	The name of the column group that you want to drop.

Exception	Description
nonmasterdef	The invocation site is not the masterdef site.
referenced	The given column group is being used in conflict detection and resolution.
missingobject	The given table does not exist.
missinggroup	The given column group does not exist.
missingschema	The given schema does not exist.