Name
DBMS_REPCAT.DEFINE_COLUMN_GROUP
Synopsis
The DEFINE_COLUMN_GROUP procedure creates a column group with no member columns. The new column group does not take effect until you call GENERATE_REPLICATION_SUPPORT for the table.
PROCEDURE DBMS_REPCAT.DEFINE_COLUMN_GROUP
(sname IN VARCHAR2,
oname IN VARCHAR2,
column_group IN VARCHAR2,
comment IN VARCHAR@ := NULL);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 |
comment | Comment |
Exceptions
Exception Name | Number | Description |
|---|---|---|
duplicategroup | –23330 | Column_group already exists. |
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.
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