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.
Get Oracle Distributed Systems now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.