Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_REPCAT.SUSPEND_MASTER_ACTIVITY

Purpose

To suspend replication activity for an object group. You must call this procedure from the master definition site. For additional information, refer to

Note: The current implementation of SUSPEND_MASTER_ACTIVITY quiesces all replicated object groups at each master site.

Syntax

The parameter for the SUSPEND_MASTER_ACTIVITY procedure is described in Table 12 - 169, and the exceptions are listed in Table 12 - 170. The syntax for this procedure is shown below:

DBMS_REPCAT.SUSPEND_MASTER_ACTIVITY(
	gname		IN	VARCHAR2
	execute_as_user	IN	BOOLEAN => FALSE)

Parameter Description
gname The name of the object group for which you want to suspend activity.
execute_as_user The default, FALSE, indicates that a deferred call is authenticated at the remote system using the authentication context of the user who originally queued the deferred call (as indicated in the ORIGIN_USER column of the DefTran view). Set this to TRUE if you want the execution of a deferred call to be authenticated at the remote system using the authentication context of the session user.

Table 12 - 169. Parameter for SUSPEND_MASTER_ACTIVITY

Exception Description
nonmasterdef The invocation site is not the master definition site.
notnormal The replicated object group is not in normal operation.
commfailure At least one master site is not accessible.
missingobjectgroup The given object group does not exist.

Table 12 - 170. Exceptions for SUSPEND_MASTER_ACTIVITY

Parameter	Description
`gname`	The name of the object group for which you want to suspend activity.
`execute_as_user`	The default, FALSE, indicates that a deferred call is authenticated at the remote system using the authentication context of the user who originally queued the deferred call (as indicated in the ORIGIN_USER column of the DefTran view). Set this to TRUE if you want the execution of a deferred call to be authenticated at the remote system using the authentication context of the session user.

Exception	Description
nonmasterdef	The invocation site is not the master definition site.
notnormal	The replicated object group is not in normal operation.
commfailure	At least one master site is not accessible.
missingobjectgroup	The given object group does not exist.