Skip Headers

Oracle® Database Advanced Replication Management API Reference
10g Release 1 (10.1)

Part Number B10733-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to current chapter
Up
Go to next page
Next
View PDF

DEFINE_COLUMN_GROUP Procedure

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

See Also:

Chapter 6, "Configure Conflict Resolution" and Oracle Database 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_GROUP Procedure Parameters  
Parameter Description
sname

Schema in which the replicated table is located.

oname

Name of the replicated table for which you are creating a column group.

column_group

Name of the column group that you want to create.

comment

This user text is displayed in the DBA_REPCOLUMN_GROUP view.

Exceptions

Table 18-62 DEFINE_COLUMN_GROUP Procedure Exceptions  
Exception Description
nonmasterdef

Invocation site is not the master definition site.

missingobject

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.