Replication Management API Reference, 71 of 179

COMMENT_ON_SNAPSHOT_REPSITES procedure

This procedure updates the SCHEMA_COMMENT field in the DBA_REPGROUP data dictionary view for the specified snapshot group. The group name must be registered locally as a replicated snapshot group. This procedure must be executed at the snapshot site.

Syntax

DBMS_REPCAT.COMMENT_ON_SNAPSHOT_REPSITES (
   gowner    IN   VARCHAR2,
   gname     IN   VARCHAR2,
   comment   IN   VARCHAR2);

Parameters

Table 8-119 COMMENT_ON_SNAPSHOT_REPSITES Procedure Parameters

Parameter	Description
gowner	Owner of the snapshot object group.
gname	Name of the snapshot object group.
comment	Updated comment to include in the `SCHEMA_COMMENT` field of the `DBA_REPGROUP` view.

Table 8-120 COMMENT_ON_SNAPSHOT_REPSITES Procedure Exceptions

Parameter	Description
missingrepgroup	The snapshot object group does not exist.
nonsnapshot	The connected site is not a snapshot site.