Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_REPCAT.DO_DEFERRED_REPCAT_ADMIN

Purpose

To execute the local outstanding deferred administrative procedures for the given replicated object group at the current master site, or (with assistance from job queues) for all master sites. For additional information, refer to

Note: DO_DEFERRED_REPCAT_ADMIN executes only those administrative requests submitted by the connected user that called DO_DEFERRED_REPCAT_ADMIN. Requests submitted by other users are ignored.

Syntax

The parameters for the DO_DEFERRED_REPCAT_ADMIN procedure are described in Table 12 - 115, and the exceptions are listed in Table 12 - 116. The syntax for this procedure is shown below:

DBMS_REPCAT.DO_DEFERRED_REPCAT_ADMIN(
			gname		IN	VARCHAR2,
			all_sites	IN	BOOLEAN := FALSE)

Parameter Description
gname The name of the replicated object group.
all_sites If ALL_SITES is TRUE, use a job to execute the local administrative procedures at each master.

Table 12 - 115. Parameters for DO_DEFERRED_REPCAT_ADMIN

Exception Description
nonmaster The invocation site is not a master site.
commfailure At least one master site is not accessible and all_sites is TRUE.

Table 12 - 116. Exceptions for DO_DEFERRED_REPCAT_ADMIN

Parameter	Description
`gname`	The name of the replicated object group.
`all_sites`	If ALL_SITES is TRUE, use a job to execute the local administrative procedures at each master.

Exception	Description
nonmaster	The invocation site is not a master site.
commfailure	At least one master site is not accessible and all_sites is TRUE.