Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_REPCAT.SWITCH_SNAPSHOT_MASTER

Purpose

To change the master database of a snapshot replicated object group to another master site. This procedure does a full refresh of the affected snapshots and regenerates the triggers and their associated packages as needed. This procedure does not push the queue to the old master site before changing masters. For additional information, refer to

Syntax

The parameters for the SWITCH_SNAPSHOT_MASTER procedure are described in Table 12 - 171, and the exceptions are listed in Table 12 - 172. The syntax for this procedure is shown below:

DBMS_REPCAT.SWITCH_SNAPSHOT_MASTER(
                  gname              IN    VARCHAR2, 
                  master             IN    VARCHAR2
                  execute_as_user    IN    BOOLEAN := FALSE)

Parameter Description
gname The name of the snapshot object group for which you want to change master sites.
master The fully qualified database name of the new master database to use for the snapshot site.
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 - 171. Parameters for SWITCH_SNAPSHOT_MASTER

Exception Description
nonsnapshot The invocation site is not a snapshot site.
nonmaster The given database is not a master site.
commfailure The given database is not accessible.

Table 12 - 172. Exceptions for SWITCH_SNAPSHOT_MASTER

Parameter	Description
`gname`	The name of the snapshot object group for which you want to change master sites.
`master`	The fully qualified database name of the new master database to use for the snapshot site.
`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
nonsnapshot	The invocation site is not a snapshot site.
nonmaster	The given database is not a master site.
commfailure	The given database is not accessible.