Oracle Distributed Systems

Name

DBMS_REPCAT.MAKE_COLUMN_GROUP

Synopsis

The MAKE_COLUMN_GROUP procedure creates a new column group and designates columns to it. It provides the functional equivalent of calling DEFINE_COLUMN_GROUP followed by ADD_GROUPED_COLUMN.

PROCEDURE DBMS_REPCAT.MAKE_COLUMN_GROUP
   (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 to which the replicated table belongs.
oname	Name of the replicated table containing the column group.
column_group	Name of the column group.
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.

Exceptions

Exception Name	Number	Description
duplicatecolumn	–23333	Column(s) already a member of a different column group.
duplicategroup	–23330	column_group already exists.
missingcolumn	–23334	Column(s) specified do not exist in table oname.
missingobject	–23308	Object oname does not exist.
nonmasterdef	–23312	Calling 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 procedure.