Name
DBMS_REPCAT.DROP_GROUPED_COLUMN
Synopsis
The DROP_GROUPED_COLUMN procedure allows you to drop one or more columns from a column group. Dropping a column from a column group is quite similar to adding one. Make sure, however, that none of your conflict resolution methods reference the column(s) that you are dropping. Changes do not take effect until GENERATE_REPLICATION_SUPPORT is called.
As with the other procedures with a list_of_column_names parameter, you can pass an asterisk (*) to the parameter to indicate all fields in table oname.
PROCEDURE DBMS_REPCAT.DROP_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 from which column(s) will be dropped |
list_of_column_names | A comma-delimited list of column names or a PL/SQL table of column names |
Exceptions
Exception Name | Number | Description |
---|---|---|
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 the master definition site. |
Restrictions
You must not call this procedure from the quiesced master definition site.
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.