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.