Name
DBMS_REPCAT.DROP_COLUMN_GROUP
Synopsis
The DROP_COLUMN_GROUP procedure drops a column group that you’ve previously created. The change does not take effect until you call GENERATE_REPLICATION_SUPPORT for the table for which the column group is defined.
PROCEDURE DBMS_REPCAT.DROP_COLUMN_GROUP
(sname IN VARCHAR2,
oname IN VARCHAR2,
column_group IN VARCHAR2);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 |
Exceptions
Exception Name | Number | Description |
|---|---|---|
missinggroup | –23331 | The column_group does not exist. |
missingobject | –23308 | The object oname does not exist. |
missingschema | –23306 | The schema sname does not exist. |
nonmasterdef | –23312 | Calling site is not master definition site. |
referenced | –23332 | The column_group is used by existing conflict resolution methods. |
Restrictions
You must call this procedure from the quiesced master definition site.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access