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.
Get Oracle Distributed Systems now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.