SWITCH_SNAPSHOT_MASTER procedure

This procedure changes the master database of a snapshot replicated master 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.

Syntax

DBMS_REPCAT.SWITCH_SNAPSHOT_MASTER (
   gname         IN   VARCHAR2, 
   master        IN   VARCHAR2
   gowner        IN   VARCHAR2  := 'PUBLIC');

Parameters

Table 8-200 SWITCH_SNAPSHOT_MASTER Procedure Parameters

Parameter	Description
gname	Name of the snapshot object group for which you want to change master sites.
master	Fully qualified database name of the new master database to use for the snapshot site.
gowner	Owner of the snapshot group.

Exceptions

Table 8-201 SWITCH_SNAPSHOT_MASTER Procedure Exceptions

Exception	Description
nonsnapshot	Invocation site is not a snapshot site.
nonmaster	Specified database is not a master site.
commfailure	Specified database is not accessible.
missingrepgroup	Snapshot group does not exist.
qrytoolong	Snapshot definition query is greater 32 KB.
alreadymastered	At the local site, there is another snapshot group with the same group name mastered at the old master site.