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