Oracle7 Server Distributed Systems Volume II: Replicated Data

Contents Index Home Previous Next

DBMS_REPCAT.DROP_GROUPED_COLUMN

Purpose

To remove members from a column group. You must call this procedure from the master definition site. For additional information, refer to [*].

Syntax

The parameters for the DROP_GROUPED_COLUMN procedure are described in Table 12 - 119, and the exceptions are listed in Table 12 - 120. The syntax for this procedure is shown below:

DBMS_REPCAT.DROP_GROUPED_COLUMN(
			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 in which the column group is located.
column_group The name of the column group from which you are removing members.
list_of_column_names The names of the columns that you are removing from the designated column group. 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.
Table 12 - 119. Parameters for DROP_GROUPED_COLUMN

Exception Description
nonmasterdef The invocation site is not the masterdef site.
missingobject The given table does not exist.
missinggroup The given column group does not exist.
missingschema The given schema does not exist.
Table 12 - 120. Exceptions for DROP_GROUPED_COLUMN


Contents Index Home Previous Next