Oracle Distributed Systems

Name

DBMS_REPCAT.ALTER_SITE_PRIORITY

Synopsis

Just as you can change the priority of a value in a priority group, you can change the priority of a site in a site priority group. Use the ALTER_SITE_PRIORITY procedure to do this. The specifications for Oracle7 and Oracle8 differ as follows.

Oracle7 specification:

PROCEDURE DBMS_REPCAT.ALTER_SITE_PRIORITY
   (gname IN VARCHAR2 := '',
    name IN VARCHAR2,
    old_priority IN NUMBER,
    new_priority IN NUMBER,
    sname IN VARCHAR2 := '');

Oracle8 specification:

PROCEDURE DBMS_REPCAT.ALTER_SITE_PRIORITY
   (gname IN VARCHAR2 := '',
    name IN VARCHAR2,
    old_priority IN NUMBER,
    new_priority IN NUMBER);
    site IN VARCHAR2);

Parameters

Parameter Name	Description
gname	Name of the replication group to which the site priority group name belongs
name	Name of the site priority group
old_priority	Site’s current priority
new_priority	Site’s new priority
sname (Oracle7 only)	Schema name (provided for pre-Oracle 7.3 compatibility)
site	Global name of the site

Exceptions

Exception Name	Number	Description
duplicatepriority	–00001	Priority new_priority already exists for the site priority group name.
missingpriority	–01403	Priority old_priority is not associated with any sites.
missingrepgroup	–23373	Replication group gname does not exist.
missingvalue	–23337	Value old_value does not already exist.
nonmasterdef	–23312	Calling site is not the master definition site.
paramtype	–23325	Parameter new_value is incorrect datatype.

Restrictions

• You must run this procedure from the master definition site.

• The new priority must ...