Oracle Distributed Systems

Name

DBMS_REPCAT.SWITCH_SNAPSHOT_MASTER

Synopsis

The SWITCH_SNAPSHOT_MASTER procedure lets you switch a snapshot replication group to a different master site. This procedure changes the master site for the specified snapshot group. The new master site must contain a replica of the replication group gname. The next time the snapshot group refreshes, Oracle performs a full refresh. Putsnapshot logs on the master tables at the new master site so that you can use fastrefreshes.

The specifications differ for Oracle7 and Oracle8 as follows.

Oracle7 specification:

PROCEDURE DBMS_REPCAT.SWITCH_SNAPSHOT_MASTER
   (gname IN VARCHAR2 := '',
    master IN VARCHAR2,
    execute_as_user IN BOOLEAN := FALSE,
    sname IN VARCHAR2 := '');

Oracle8 specification:

PROCEDURE DBMS_REPCAT.SWITCH_SNAPSHOT_MASTER
   (gname IN VARCHAR2 := '',
    master IN VARCHAR2)

Parameters

Parameter Name	Description
gname	Name of the snapshot group.
master	Name of the new master site.
execute_as_user (Oracle7 only)	FALSE (the default) indicates that the remote system will authenticate calls using the authentication context user who originally queued the RPC; TRUE indicates that the remote system will use authentication context of the session user.
sname (Oracle7 only)	Schema name (provided for pre-Oracle 7.3 compatibility).

Exceptions

Exception Name	Number	Description
commfailure	–23317	Unable to communicate with the master site.
nonmaster	–23312	The master parameter is not a master site.
nonsnapshot	–23314	Calling site is not a snapshot site.

Restrictions

• The new master ...