DEFINE_COLUMN_GROUP Procedure

DEFINE_ COLUMN_GROUP Procedure

This procedure creates an empty column group. You must call th is procedure from the master definition site.

See Also:

Chapter 6, "Configure Confli ct Resolution" and Oracle Da tabase Advanced Replication for more information about conflict resolution methods

Syntax

DBMS_REPCAT.DEFINE_COLUMN_GROUP ( 
   sname            IN   VARCHAR2,
   oname
  IN   VARCHAR2,
   column_group     IN   VARCHAR2,
   comment          IN   VARCHAR2 := NULL
);

Parameters

Table 18-61 DEFINE_COLUMN_G ROUP Procedure Parameters

Exceptions

Table 18-62 DEFINE_COLUMN_GROU P Procedure Exceptions

Parameter	Description
sname	Schema in which the replicated table is located.< /p>
oname	Name of the replicated table for which you are creating a column group. < /td>
column_group	Name of the column group that you want to create.
comment	This user text is displayed in the `DBA_REPCOLUMN_GROUP` view.

Exception	Description
nonmasterdef	Invocation site is not the master definition site.
missingobj ect	Specified table does not exist.
duplicategroup	Specified column group already exists for the table.
notquiesced	Replication group to which the specified table belongs is not quiesced.