Oracle Distributed Systems

Name

DBMS_REPCAT.ALTER_SNAPSHOT_PROPAGATION

Synopsis

Call the ALTER_SNAPSHOT_PROPAGATION procedure to change the propagation mode of a particular snapshot. Specifications for Oracle7 and Oracle8 differ.

Oracle7 specification:

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

Oracle8 specification:

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

Parameters

Parameter Name	Description
gname	Name of the replication group to be altered.
propagation_mode	The new propagation mode to use (SYNCHRONOUS or ASYNCHRONOUS).
comment	Comment visible in DBA_REPPROP data dictionary view.
execute_as_user (Oracle7 only)	FALSE (default) indicates that remote system will authenticate calls using authentication context user who originally queued the RPC; TRUE indicates that remote system will use authentication context of the session user.

Exceptions

Exception Name	Number	Description
dbnotcompatible	–23375	Database version is not 7.3 or later.
missingrepgroup	–23373	Replication group gname does not exist.
typefailure	–23319	Invalid propagation_mode.

Restrictions

This procedure must be called from a snapshot site.