Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_REPCAT.ALTER_SNAPSHOT_PROPAGATION

Purpose

To alter the propagation method for a given object group at the current snapshot site. This procedure pushes the deferred transaction queue at the snapshot site, locks the snapshot base tables, and regenerates any triggers and their associated packages. You must call this procedure from the snapshot site. For additional information, refer to

Syntax

The parameters for the ALTER_SNAPSHOT_PROPAGATION procedure are described in Table 12 - 84, and the exceptions are listed in Table 12 - 85. The syntax for this procedure is shown below:

DBMS_REPCAT.ALTER_SNAPSHOT_PROPAGATION(
           gname             IN  VARCHAR2, 
           propagation_mode  IN  VARCHAR2,
           comment           IN  VARCHAR2 := ''
           execute_as_user   IN  BOOLEAN := FALSE)

Parameter Description
gname The name of the object group that you want to alter.
propagation_mode Determines the manner in which changes from the current snapshot site are propagated to its associated master site. Appropriate values are SYNCHRONOUS and ASYNCHRONOUS.
comment This comment is added to the RepProp view.
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 - 84. Parameters for ALTER_SNAPSHOT_PROPAGATION

Exception Description
notcompat Only databases operating in 7.3.0 or later mode can use this procedure.
missingrepgroup The given replicated object group does not exist.
typefailure The propagation mode was specified incorrectly.

Table 12 - 85. Exceptions for ALTER_SNAPSHOT_PROPAGATION

Parameter	Description
`gname`	The name of the object group that you want to alter.
`propagation_mode`	Determines the manner in which changes from the current snapshot site are propagated to its associated master site. Appropriate values are SYNCHRONOUS and ASYNCHRONOUS.
`comment`	This comment is added to the RepProp view.
`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
notcompat	Only databases operating in 7.3.0 or later mode can use this procedure.
missingrepgroup	The given replicated object group does not exist.
typefailure	The propagation mode was specified incorrectly.