Oracle Distributed Systems

Name

DBMS_REPCAT.DROP_GROUPED_COLUMN

Synopsis

The DROP_GROUPED_COLUMN procedure allows you to drop one or more columns from a column group. Dropping a column from a column group is quite similar to adding one. Make sure, however, that none of your conflict resolution methods reference the column(s) that you are dropping. Changes do not take effect until GENERATE_REPLICATION_SUPPORT is called.

As with the other procedures with a list_of_column_names parameter, you can pass an asterisk (*) to the parameter to indicate all fields in table oname.

PROCEDURE DBMS_REPCAT.DROP_GROUPED_COLUMN
   (sname IN VARCHAR2,
    oname IN VARCHAR2,
    column_group IN VARCHAR2,
    {list_of_column_names IN VARCHAR2 |
    list_of_column_names IN dbms_repcat.varchar2s});

Note that you must specify only one of the list_of_column_names parameters.

Parameters

Parameter Name	Description
sname	Name of the schema that owns the replicated table
oname	Name of the table with the column_group
column_group	Name of the column_group from which column(s) will be dropped
list_of_column_names	A comma-delimited list of column names or a PL/SQL table of column names

Exceptions

Exception Name	Number	Description
missinggroup	–23331	Column group column_group does not exist.
missingobject	–23308	Table oname does not exist.
missingschema	–23306	Schema sname does not exist.
nonmasterdef	–23312	Invoking site is not the master definition site.

Restrictions

You must not call this procedure from the quiesced master definition site.