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_MASTER_REPGROUP Procedure

This procedure drops a master group from your current site. To drop the master group from all master sites, including the master definition site, you can call this procedure at the master definition site, and set all_sites to true.

Syntax

DBMS_REPCAT.DROP_MASTER_REPGROUP (
   gname             IN VARCHAR2,
   drop_contents     IN BOOLEAN    := false,
   all_sites         IN BOOLEAN    := false);

Parameters

Table 18-73 DROP_MASTER_REPGROUP Procedure Parameters  
Parameter Description
gname

Name of the master group that you want to drop from the current master site.

drop_contents

By default, when you drop the replication group at a master site, all of the objects remain in the database. They simply are no longer replicated. That is, the replicated objects in the replication group no longer send changes to, or receive changes from, other master sites. If you set this to true, then any replicated objects in the master group are dropped from their associated schemas.

all_sites

If this is true and if the invocation site is the master definition site, then the procedure synchronously multicasts the request to all masters. In this case, execution is immediate at the master definition site and may be deferred at all other master sites.

Exceptions

Table 18-74 DROP_MASTER_REPGROUP Procedure Exceptions  
Exception Description
nonmaster

Invocation site is not a master site.

nonmasterdef

Invocation site is not the master definition site and all_sites is true.

commfailure

At least one master site is not accessible and all_sites is true.

fullqueue

Deferred remote procedure call (RPC) queue has entries for the master group.

masternotremoved

Master does not recognize the master definition site and all_sites is true.