Oracle Distributed Systems

Name

DBMS_REPCAT.ADD_GROUPED_COLUMN

Synopsis

The ADD_GROUPED_COLUMN procedure adds a member column to a column group. You can call this procedure after you have created a new, empty column group with DEFINE_COLUMN_GROUP or if your schema or conflict resolution requirements change.

PROCEDURE DBMS_REPCAT.ADD_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 to which column(s) will be added.
list_of_column_names	A comma-delimited list of column names, or a PL/SQL table of column names. Use an asterisk (*) to add all columns in the table to the column group.

Exceptions

Exception Name	Number	Description
duplicatecolumn	–23333	Column(s) specified already exist in column_group.
missingcolumn	–23334	Column(s) specified do not exist in table oname.
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 master definition site.

Restrictions

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

• You must regenerate replication support for the table after defining the column group with the GENERATE_REPLICATION_SUPPORT ...