ALTER_SNAPSHOT_PROPAGATION procedure

This procedure alters the propagation method for a specified 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.

Syntax

DBMS_REPCAT.ALTER_SNAPSHOT_PROPAGATION (
   gname                IN  VARCHAR2, 
   propagation_mode     IN  VARCHAR2,
   comment              IN  VARCHAR2   := ''
   gowner               IN  VARCHAR2   := 'PUBLIC');

Parameters

Table 8-105 ALTER_SNAPSHOT_PROPAGATION Procedure Parameters

Parameter	Description
gname	Name of the object group for which to alter propagation mode.
propagation_mode	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 DBA_REPPROP view.
gowner	Owner of the snapshot group.

Exceptions

Table 8-106 ALTER_SNAPSHOT_PROPAGATION Procedure Exceptions

Exception	Description
missingrepgroup	Specified replicated master group does not exist.
typefailure	Propagation mode was specified incorrectly.
nonsnapshot	Current site is not a snapshot site for the specified object group.
commfailure	Cannot contact master.
notcompat	Compatibility mode must be 7.3.0.0 or greater.
failaltersnaprop	Snapshot group propagation can be altered only when there are no other snapshot groups with the same master sharing the snapshot site.