Replication Management API Reference, 70 of 179

COMMENT_ON_REPSITES procedure

If the object group is a master group, this procedure updates the MASTER_COMMENT field in the DBA_REPSITES view for a master site. If the object group is a snapshot group, this procedure updates the SCHEMA_COMMENT field in the DBA_REPGROUP view for a snapshot site.

This procedure can be executed at either a master site or a snapshot site. If you execute this procedure on a a snapshot site, the snapshot group owner must be PUBLIC.

See Also:
"COMMENT_ON_SNAPSHOT_REPSITES procedure" for instructions on placing a comment in the SCHEMA_COMMENT field of the DBA_REPGROUP view for a snapshot site if the snapshot group owner is not PUBLIC.

Syntax

DBMS_REPCAT.COMMENT_ON_REPSITES ( 
   gname       IN   VARCHAR2, 
   [ master    IN   VARCHAR,] 
   comment     IN   VARCHAR2);

Parameters

Table 8-117 COMMENT_ON_REPSITES Procedure Parameters

Parameter	Description
gname	Name of the object group. This avoids confusion if a database is a master site in more than one replicated environment.
master	(Optional) The fully qualified database name of the master site on which you want to comment. If you are executing the procedure on a master site, this parameter is required. To update comments at a snapshot site, omit this parameter.
comment	Text of the updated comment that you want to include in the comment field of the appropriate dictionary view. If the site is a master site, this procedure updates the `MASTER_COMMENT` field of the `DBA_REPSITES` view. If the site is a snapshot site, this procedure updates the `SCHEMA_COMMENT` field of the `DBA_REPGROUP` view.

Exceptions

Table 8-118 COMMENT_ON_REPSITES Procedure Exceptions

Exception	Description
nonmasterdef	Invocation site is not the master definition site.
nonmaster	Invocation site is not a master site.
commfailure	At least one master site is not accessible.
missingrepgroup	Object group does not exist.
commfailure	One or more master sites are not accessible.
corrupt	There is an inconsistency in the replication catalog views.