Name
DBMS_REPCAT.ALTER_PRIORITY
Synopsis
The ALTER_PRIORITY procedure lets you change the priority associated with a specific value in a priority group. The change takes place immediately. The specifications differ for Oracle7 and Oracle8 as follows.
Oracle7 specification:
PROCEDURE DBMS_REPCAT.ALTER_PRIORITY
(gname IN VARCHAR2 := '',
pgroup IN VARCHAR2,
old_priority IN NUMBER,
new_priority IN NUMBER,
sname IN VARCHAR2 := '');Oracle8 specification:
PROCEDURE DBMS_REPCAT.ALTER_PRIORITY
(gname IN VARCHAR2 := '',
pgroup IN VARCHAR2,
old_priority IN NUMBER,
new_priority IN NUMBER)Parameters
Parameter Name | Description |
|---|---|
gname | Name of the replication group to which priority group pgroup belongs |
pgroup | Name of the priority group whose priority is being altered |
old_priority | pgroup’s previous priority value |
new_priority | pgroup’s new priority value |
sname (Oracle7 only) | Schema name (provided for pre-Oracle 7.3 compatibility) |
Exceptions
Exception Name | Number | Description |
|---|---|---|
duplicatepriority | –23335 | Priority new_priority already exists in priority group pgroup. |
missingprioritygroup | –23336 | Priority group pgroup does not exist. |
missingvalue | –23337 | Value was not registered with a call to ADD_PRIORITY_datatype. |
nonmasterdef | –23312 | Calling site is not the master definition site. |
Restrictions
You must call the ALTER_PRIORITY procedure from the master definition site.
The new priority must be unique within the priority group.