Replication Management API Reference, 79 of 179

DEFINE_PRIORITY_GROUP procedure

This procedure creates a new priority group for a replicated master group. You must call this procedure from the master definition site.

See Also:
Oracle8i Replication for more information about conflict resolution methods.

Syntax

DBMS_REPCAT.DEFINE_PRIORITY_GROUP (
   gname         IN   VARCHAR2, 
   pgroup        IN   VARCHAR2, 
   datatype      IN   VARCHAR2, 
   fixed_length  IN   INTEGER := NULL,
   comment       IN   VARCHAR2 := NULL);

Parameters

Table 8-137 DEFINE_PRIORITY_GROUP Procedure Parameters

Parameter	Description
gname	Replicated master group for which you are creating a priority group.
pgroup	Name of the priority group that you are creating.
datatype	Datatype of the priority group members. The datatypes supported are: `CHAR`, `VARCHAR2`, `NUMBER`, `DATE`, `RAW`, `NCHAR`, and `NVARCHAR2`.
fixed_length	You must provide a column length for the `CHAR` datatype. All other types can use the default, `NULL`.
comment	This user comment is added to the `DBA_REPPRIORITY` view.

Exceptions

Table 8-138 DEFINE_PRIORITY_GROUP Procedure Exceptions

Exception	Description
nonmasterdef	Invocation site is not the master definition site.
missingrepgroup	Specified replicated master group does not exist.
duplicatepriority group	Specified priority group already exists in the replicated master group.
typefailure	Specified datatype is not supported.
notquiesced	Replicated master group is not quiesced.