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.