Oracle7 Server Distributed Systems Volume II: Replicated Data
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