Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_REPCAT.ADD_SITE_PRIORITY_SITE

Purpose

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

Syntax

The parameters for the ADD_SITE_PRIORITY_SITE procedure are described in Table 12 - 68, and the exceptions are listed in Table 12 - 69. The syntax for this procedure is shown below:

DBMS_REPCAT.ADD_SITE_PRIORITY_SITE(
				gname		IN	VARCHAR2, 
				name		IN	VARCHAR2
				site		IN	VARCHAR2,
				priority	IN	NUMBER)

Parameter Description
gname The replicated object group for which you are adding a site to a group.
pgroup The name of the site priority group to which you are adding a member.
site The global database name of the site that you are adding.
priority The priority level of the site that you are adding. A higher number indicates a higher priority level.

Table 12 - 68. Parameters for ADD_SITE_PRIORITY_SITE

Exception Description
nonmasterdef The invocation site is not the masterdef site.
missingrepgroup The given replicated object group does not exist.
missingpriority The given site priority group does not exist.
duplicatepriority The given priority level already exists for another site in the group.

Table 12 - 69. Exceptions for ADD_SITE_PRIORITY_SITE

Parameter	Description
`gname`	The replicated object group for which you are adding a site to a group.
`pgroup`	The name of the site priority group to which you are adding a member.
`site`	The global database name of the site that you are adding.
`priority`	The priority level of the site that you are adding. A higher number indicates a higher priority level.

Exception	Description
nonmasterdef	The invocation site is not the masterdef site.
missingrepgroup	The given replicated object group does not exist.
missingpriority	The given site priority group does not exist.
duplicatepriority	The given priority level already exists for another site in the group.