Replication Management API Reference, 101 of 179

REGISTER_SNAPSHOT_REPGROUP procedure

This procedure facilitates the administration of snapshots at their respective master sites by inserting or modifying a snapshot group in DBA_REGISTERED_SNAPSHOT_GROUPS.

Syntax

DBMS_REPCAT.REGISTER_SNAPSHOT_REPGROUP (
   gname            IN   VARCHAR2,
   snapsite         IN   VARCHAR2,
   comment          IN   VARCHAR2  := NULL,
   rep_type         IN   NUMBER    := reg_unknown,
   fname            IN   VARCHAR2  := NULL
   gowner           IN   VARCHAR2  := 'PUBLIC');

Parameters

Table 8-182 REGISTER_SNAPSHOT_REPGROUP Procedure Parameters

Parameter	Description
gname	Name of the snapshot object group to be registered.
snapsite	Global name of the snapshot site.
comment	Comment for the snapshot site or update for an existing comment.
rep_type	Version of the snapshot group. Valid constants that can be assigned include `reg_unknown` (the default), `reg_v7_group`, `reg_v8_group`, and `reg_repapi_group`.
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-183 REGISTER_SNAPSHOT_REPGROUP Procedure Exceptions

Exception Description

failregsnaprepgroup

Registration of snapshot group failed.

missingrepgroup

Object group name not specified.

nullsitename

A snapshot site was not specified.

nonmaster

Procedure must be executed at the snapshot's master site.

duplicaterepgroup

Object already exists.

Exception	Description
failregsnaprepgroup	Registration of snapshot group failed.
missingrepgroup	Object group name not specified.
nullsitename	A snapshot site was not specified.
nonmaster	Procedure must be executed at the snapshot's master site.
duplicaterepgroup	Object already exists.