Name
DBMS_REPCAT.DROP_PRIORITY_GROUP
Synopsis
The DROP_PRIORITY_GROUP procedure lets you drop a priority group that you have defined. The change does not go into effect until the next call to GENERATE_REPLICATION_SUPPORT. Do not drop a priority group that you have designated as an UPDATE conflict resolution method for a column group. You must first use DROP_UPDATE_RESOLUTION for the column group. Records in the data dictionary view DBA_REPRESOLUTION indicate if and where the priority group is used. Attempting to drop a priority group that is in use raises the referenced exception.
The specifications differ for Oracle7 and Oracle8 as follows.
Oracle7 specification:
PROCEDURE DBMS_REPCAT.DROP_PRIORITY_GROUP
(gname IN VARCHAR2 := '',
pgroup IN VARCHAR2,
sname IN VARCHAR2 := '');Oracle8 specification:
PROCEDURE DBMS_REPCAT.DROP_PRIORITY_GROUP
(gname IN VARCHAR2 := '',
pgroup IN VARCHAR2);Parameters
Parameter Name | Description |
|---|---|
gname | Name of the replication group containing the priority group |
pgroup | Name of the priority group to drop |
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 | Priority group pgroup is used by existing conflict resolution methods. |
Restrictions
You must call DROP_PRIORITY_GROUP from the master definition site.