Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_REPCAT.DROP_SITE_PRIORITY_SITE

Purpose

To drop a given site, by name, from a site priority group. You must call this procedure from the master definition site. For additional information, refer to

Syntax

The parameters for the DROP_SITE_PRIORITY_SITE procedure are described in Table 12 - 133, and the exceptions are listed in Table 12 - 134. The syntax for this procedure is shown below:

drop_site_priority_site(	gname	IN	VARCHAR2, 
	name	IN	VARCHAR2
	site	IN	VARCHAR2)

Parameter Description
gname The replicated object group with which the site priority group is associated.
name The name of the site priority group whose member you are dropping.
site The global database name of the site you are removing from the group.

Table 12 - 133. Parameters for DROP_SITE_PRIORITY_SITE

Exception Description
nonmasterdef The invocation site is not the masterdef site.
missingrepgroup The given replicated object group does not exist.
missingpriority The given site priority group does not exist.
missingsite The given site does not exist.

Table 12 - 134. Exceptions for DROP_SITE_PRIORITY_SITE

Parameter	Description
`gname`	The replicated object group with which the site priority group is associated.
`name`	The name of the site priority group whose member you are dropping.
`site`	The global database name of the site you are removing from the group.

Exception	Description
nonmasterdef	The invocation site is not the masterdef site.
missingrepgroup	The given replicated object group does not exist.
missingpriority	The given site priority group does not exist.
missingsite	The given site does not exist.