Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_REPCAT.DEFINE_SITE_PRIORITY

Purpose

To create a new site priority group for a replicated object group. You must call this procedure from the master definition site. For additional information, refer to

Syntax

The parameters for the DEFINE_SITE_PRIORITY procedure are described in Table 12 - 113, and the exceptions are listed in Table 12 - 114. The syntax for this procedure is shown below:

DBMS_REPCAT.DEFINE_SITE_PRIORITY(
			gname		IN	VARCHAR2, 
			name		IN	VARCHAR2,
			comment	IN	VARCHAR2 := NULL)

Parameter Description
gname The replicated object group for which you are creating a site priority group.
name The name of the site priority group that you are creating.
comment This user comment is added to the RepPriority view.

Table 12 - 113. Parameters for DEFINE_SITE_PRIORITY

Exception Description
nonmasterdef The invocation site is not the masterdef site.
missingrepgroup The given replicated object group does not exist.
duplicateprioritygroup The given site priority group already exists in the replicated object group.

Table 12 - 114. Exceptions for DEFINE_SITE_PRIORITY

Parameter	Description
`gname`	The replicated object group for which you are creating a site priority group.
`name`	The name of the site priority group that you are creating.
`comment`	This user comment is added to the RepPriority view.

Exception	Description
nonmasterdef	The invocation site is not the masterdef site.
missingrepgroup	The given replicated object group does not exist.
duplicateprioritygroup	The given site priority group already exists in the replicated object group.