Replication Management API Reference, 84 of 179

DROP_MASTER_REPGROUP procedure

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

Syntax

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

Parameters

Table 8-147 DROP_MASTER_REPGROUP Procedure Parameters

Parameter	Description
gname	Name of the replicated master group that you want to drop from the current master site.
drop_contents	By default, when you drop the object 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 object 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 replicated 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 8-148 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 RPC queue has entries for the replicated master group.
masternotremoved	Master does not recognize the master definition site and `ALL_SITES` is `TRUE`.