Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_REPCAT.ALTER_SITE_PRIORITY_SITE

Purpose

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

Syntax

The parameters for the ALTER_SITE_PRIORITY_SITE procedure are described in Table 12 - 82, and the exceptions are listed in Table 12 - 83. The syntax for this procedure is shown below:

DBMS_REPCAT.ALTER_SITE_PRIORITY_SITE(	gname	IN	VARCHAR2,
	name	IN	VARCHAR2
	old_site	IN	VARCHAR2,
	new_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 altering.
old_site The current global database name of the site whose name you want to change.
new_site The new global database name that you want to associate with the current priority level.

Table 12 - 82. Parameters for ALTER_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
missingvalue The old site is not a group member.
duplicatesite The new site already exists in the group with a different priority level.

Table 12 - 83. Exceptions for ALTER_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 altering.
`old_site`	The current global database name of the site whose name you want to change.
`new_site`	The new global database name that you want to associate with the current priority level.

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
missingvalue	The old site is not a group member.
duplicatesite	The new site already exists in the group with a different priority level.