Name
DBMS_REPCAT.DROP_SITE_PRIORITY
Synopsis
The DROP_SITE_PRIORITY procedure drops an existing site priority group that is no longer in use. The change does not go into effect until the next call to GENERATE_REPLICATION_SUPPORT. As with the DROP_PRIORITY_GROUP procedure, do not attempt to drop a site priority group that is acting as an UPDATE conflict resolution handler for a column group. First, use DROP_UPDATE_RESOLUTION to drop the conflict handler for the column group.
Specifications differ for Oracle7 and Oracle8 as follows.
Oracle7 specification:
PROCEDURE DBMS_REPCAT.DROP_SITE_PRIORITY
(gname IN VARCHAR2 := '',
name IN VARCHAR2,
sname IN VARCHAR2 := '');Oracle8 specification:
PROCEDURE DBMS_REPCAT.DROP_SITE_PRIORITY
(gname IN VARCHAR2 := '',
name IN VARCHAR2)Parameters
Parameter Name | Description |
|---|---|
gname | Name of the replication group containing the site priority group |
name | Name of the site priority group |
sname (Oracle7 only) | Schema name (provided for pre-Oracle 7.3 compatibility) |
Exceptions
Exception Name | Number | Description |
|---|---|---|
missingrepgroup | –23373 | Replication group gname does not exist. |
nonmasterdef | –23312 | Calling site is not the master definition site. |
referenced | –23332 | Site priority group is used by existing conflict resolution method. |
Restrictions
You must call DROP_SITE_PRIORITY from the master definition site.