ALTER_PRIORITY Procedure

ALTER_PRIORI TY Procedure

This procedure alters the priority level associated with a specified pri ority group member. You must call this procedure from the master definition site.

See Also:

Chapter 6, "Configure Conflict Resolution" and Oracle Database Advanced Replication for more information about conflict resolution methods

Syntax< /h3>

DBMS_REPCAT.ALTER_PRIORITY (
   gname            IN   VARCHAR2, 
   pgroup           IN   VARCHAR2, 
   old_priority     IN   NUMBER, 
   new_pr
iority     IN   NUMBER);

Para meters

Ta ble 18-23 ALTER_PRIORITY Procedure Parameters

Parameter	Description
gname	Master group with which t he priority group is associated.
pgroup	Name of the priority group containing th e priority that you want to alter.
< a name="118852">old_priority	Current priority level of the pr iority group member.
new_priority	New priority level that you want assigned to t he priority group member.

Exceptions

Table 18-24 ALTER_PRIORITY Procedure Exceptions

< td class="Formal">

notquiesced

E xception	Description
nonmasterdef	I nvocation site is not the master definition site.
duplicatepriority	New priority l evel already exists in the priority group.
missingrepgroup	Specified master group does not exist.
missingvalue	Value was not registered by a call to `DBMS_REPC AT`.`ADD_PRIORITY_``datatype`.
missingprioritygroup	Specified priority group does not exist.
Specified master group is not quiesced.