Oracle Distributed Systems

Name

DBMS_REPCAT.CREATE_SNAPSHOT_REPGROUP

Synopsis

This procedure creates a new, empty snapshot replication group. If you will be creating the snapshot group at multiple sites, it is advisable to create a script to perform this call because there is no analogy to ADD_MASTER_DATABASE for snapshot groups.

PROCEDURE DBMS_REPCAT.CREATE_SNAPSHOT_REPGROUP

   (gname IN VARCHAR2,
    master IN VARCHAR2,
    comment IN VARCHAR2 := '',
    propagation_mode IN VARCHAR2 := 'ASYNCHRONOUS');

Parameters

Parameter Name	Description
gname	Name of the new snapshot group
master	Global name of master site
comment	Comment for the snapshot group, visible in DBA_REPSITES data dictionary view
propagation_mode	Snapshot propagation mode (SYNCHRONOUS or ASYNCHRONOUS)

Exceptions

Exception Name	Number	Description
commfailure	–23317	Unable to communicate with master.
dbnotcompatible	–23375	Attempt to use SYNCHRONOUS propagation in pre-7.3 database.
duplicaterepgroup	–23374	Replication group gname already exists.
nonmaster	–23312	The master parameter is not a master site.
norepoption	–23364	Replication option not installed.
typefailure	–23319	propagation_mode not specified correctly.

Restrictions

• You must be connected to the replication administrator account (typically REPADMIN) to call the CREATE_SNAPSHOT_REPGROUP procedure.

• The snapshot group name must match the name of the master replication group.

• You must invoke this procedure from the snapshot site.