Oracle9i Supplied PL/SQL Packages and Types Reference
Release 1 (9.0.1)

Part Number A89852-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

DBMS_REPCAT, 35 of 69


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 48-71 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 48-72 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


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback