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

DROP_COLUMN_GROUP Procedure

This procedure drops a 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.DROP_COLUMN_GROUP (
   sname        IN   VARCHAR2,
   oname        IN   VARCHAR2,
   column_group IN   VARCHAR2);

Parameters

Table 18-69 DROP_COLUMN_GROUP Procedure Parameters  
Parameter Description
sname

Schema in which the replicated table is located.

oname

Name of the replicated table whose column group you are dropping.

column_group

Name of the column group that you want to drop.

Exceptions

Table 18-70 DROP_COLUMN_GROUP Procedure Exceptions  
Exception Description
nonmasterdef

Invocation site is not the master definition site.

referenced

Specified column group is being used in conflict detection and resolution.

missingobject

Specified table does not exist.

missinggroup

Specified column group does not exist.

notquiesced

Master group to which the table belongs is not quiesced.