Skip Headers

Oracle® Database Advanced Replication Management API Reference
10g Release 1 (10.1)

Part Number B10733-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to current chapter
Up
Go to next page
Next
View PDF

DEFINE_PRIORITY_GROUP Procedure

This procedure creates a new priority group for a master group. 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

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 18-63 DEFINE_PRIORITY_GROUP Procedure Parameters  
Parameter Description
gname

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 18-64 DEFINE_PRIORITY_GROUP Procedure Exceptions  
Exception Description
nonmasterdef

Invocation site is not the master definition site.

missingrepgroup

Specified master group does not exist.

duplicatepriority 
group

Specified priority group already exists in the master group.

typefailure

Specified datatype is not supported.

notquiesced

Master group is not quiesced.