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.