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 ...