Oracle Distributed Systems

Name

DBMS_REPCAT.DROP_SITE_PRIORITY_SITE

Synopsis

The DROP_SITE_PRIORITY_SITE procedure removes a site from a site priority. The change takes effect immediately. Specifications for Oracle7 and Oracle8 differ as follows.

Oracle7 specification:

PROCEDURE DBMS_REPCAT.DROP_SITE_PRIORITY_SITE
  (gname IN VARCHAR2 := '',
   name IN VARCHAR2,
   site IN VARCHAR2,
   sname IN VARCHAR2 := '');

Oracle8 specification:

PROCEDURE DBMS_REPCAT.DROP_SITE_PRIORITY_SITE
   (gname IN VARCHAR2 := '',
    name IN VARCHAR2,
    site IN VARCHAR2);

Parameters

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

Exceptions

Exception Name	Number	Description
missingpriority	–1403	Site priority does not exist.
missingrepgroup	–23373	Replication group gname does not exist.
nonmasterdef	–23312	Calling site is not the master definition site.

Restrictions

You must call DROP_SITE_PRIORITY_SITE from the master definition site.