Replication Management API Reference, 76 of 179

CREATE_SNAPSHOT_REPGROUP procedure

This procedure creates a new, empty snapshot group in your local database. CREATE_SNAPSHOT_REPGROUP automatically calls REGISTER_SNAPSHOT_REPGROUP, but ignores any errors that may have happened during registration.

Syntax

DBMS_REPCAT.CREATE_SNAPSHOT_REPGROUP (
   gname              IN   VARCHAR2, 
   master             IN   VARCHAR2, 
   comment            IN   VARCHAR2     := '',
   propagation_mode   IN   VARCHAR2     := 'ASYNCHRONOUS',
   fname              IN   VARCHAR2     := NULL
       gowner                        IN   VARCHAR2     := 'PUBLIC');

Parameters

Table 8-131 CREATE_SNAPSHOT_REPGROUP Procedure Parameters

Parameter	Description
gname	Name of the replicated master group. This object group must exist at the specified master site.
master	Fully qualified database name of the database in the replicated environment to use as the master. You can include a connection qualifier if necessary. See Oracle8i Replication and Oracle8i Distributed Database Systems for information about using connection qualifiers.
comment	This comment is added to the `DBA_REPGROUP` view.
propagation_mode	Method of propagation for all updatable snapshots in the object group. Acceptable values are `SYNCHRONOUS` and `ASYNCHRONOUS`.
fname	This parameter is for internal use only. Do not set this parameter unless directed to do so by Oracle Worldwide Support.
gowner	Owner of the snapshot group.

Exceptions

Table 8-132 CREATE_SNAPSHOT_REPGROUP Procedure Exceptions

Exception	Description
duplicaterepgroup	Object group already exists at the invocation site.
nonmaster	Specified database is not a master site.
commfailure	Specified database is not accessible.
norepopt	Advanced replication option is not installed.
typefailure	Propagation mode was specified incorrectly.
missingrepgroup	Replicated master group does not exist at master site.
invalidqualifier	Connection qualifier specified for master is not valid for the object group.
alreadymastered	At the local site, there is another snapshot group with the same group name, but different master site.