Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_REPCAT.ALTER_SITE_PRIORITY

Purpose

To alter the priority level associated with a given site. You must call this procedure from the master definition site. For additional information, refer to

Syntax

The parameters for the ALTER_SITE_PRIORITY procedure are described in Table 12 - 80, and the exceptions are listed in Table 12 - 81. The syntax for this procedure is shown below:

DBMS_REPCAT.ALTER_SITE_PRIORITY(	gname	IN	VARCHAR2,
	name	IN	VARCHAR2
	old_priority	IN	NUMBER,
	new_priority	IN	NUMBER)

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 altering.
old_priority The current priority level of the site whose priority level you want to change.
new_priority The new priority level for the site. A higher number indicates a higher priority level.

Table 12 - 80. Parameters for ALTER_SITE_PRIORITY

Exception Description
nonmasterdef The invocation site is not the masterdef site.
missingrepgroup The given replicated object group does not exist.
missingpriority The old priority level is not associated with any group members.
duplicatepriority The new priority level already exists for another site in the group.
missingvalue The old value does not already exist.
paramtype The new value has the incorrect datatype for the priority group.

Table 12 - 81. Exceptions for ALTER_SITE_PRIORITY

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 altering.
`old_priority`	The current priority level of the site whose priority level you want to change.
`new_priority`	The new priority level for the site. A higher number indicates a higher priority level.

Exception	Description
nonmasterdef	The invocation site is not the masterdef site.
missingrepgroup	The given replicated object group does not exist.
missingpriority	The old priority level is not associated with any group members.
duplicatepriority	The new priority level already exists for another site in the group.
missingvalue	The old value does not already exist.
paramtype	The new value has the incorrect datatype for the priority group.