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

MAKE_COLUMN_GROUP Procedure

This procedure creates a new column group with one or more members. 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.MAKE_COLUMN_GROUP ( 
   sname                 IN   VARCHAR2,
   oname                 IN   VARCHAR2,
   column_group          IN   VARCHAR2,
   list_of_column_names  IN   VARCHAR2 | DBMS_REPCAT.VARCHAR2s);

Parameters

Table 18-100 MAKE_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 new column group. The table can be the storage table of a nested table.

column_group

Name that you want assigned to the column group that you are creating.

list_of_column_names

Names of the columns that you are grouping. This can either be a comma-delimited list or a PL/SQL index-by table of column names. The PL/SQL index-by table must be of type DBMS_REPCAT.VARCHAR2. Use the single value '*' to create a column group that contains all of the columns in your table.

You can specify column objects, but you cannot specify attributes of column objects.

If the table is an object table, then you can specify SYS_NC_OID$ to add the object identifier column to the column group. This column tracks the object identifier of each row object.

If the table is the storage table of a nested table, then you can specify NESTED_TABLE_ID to add the column that tracks the identifier for each row of the nested table.

Exceptions

Table 18-101 MAKE_COLUMN_GROUP Procedure Exceptions  
Exception Description
nonmasterdef

Invocation site is not the masterdef site.

duplicategroup

Specified column group already exists for the table.

missingobject

Specified table does not exist.

missingcolumn

Specified column does not exist in the designated table.

duplicatecolumn

Specified column is already a member of another column group.

notquiesced

Master group is not quiesced.