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 ...
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.