Replication Management API Reference, 63 of 179

ALTER_SITE_PRIORITY_SITE procedure

This procedure alters the site associated with a specified priority level. You must call this procedure from the master definition site.

See Also:
Oracle8i Replication for more information about conflict resolution methods.

Syntax

DBMS_REPCAT.ALTER_SITE_PRIORITY_SITE (
   gname     IN   VARCHAR2,
   name      IN   VARCHAR2,
   old_site  IN   VARCHAR2,
   new_site  IN   VARCHAR2);

Parameters

Table 8-103 ALTER_SITE_PRIORITY_SITE Procedure Parameters

Parameter	Description
gname	Replicated master group with which the site priority group is associated.
name	Name of the site priority group whose member you are altering.
old_site	Current global database name of the site to disassociate from the priority level.
new_site	New global database name that you want to associate with the current priority level.

Exceptions

Table 8-104 ALTER_SITE_PRIORITY_SITE Procedure Exceptions

Exception	Description
nonmasterdef	Invocation site is not the master definition site.
missingrepgroup	Specified replicated master group does not exist.
missingpriority	Specified site priority group does not exist.
missingvalue	Old site is not a group member.
notquiesced	Replicated master group is not quiesced