COMMENT_ON_REPSITES Procedure

COMMENT_ ON_REPSITES Procedure

If the replication group is a master group, then this procedure updates the MASTER_COMMENT field in the DBA_REPSITES view for a master site. If the replication group is a materialized view group, this procedure updates the SCHEMA_COMMENT field in the DBA_REPGROUP view for a ma terialized view site.

This procedure can be executed at either a master site or a materialize d view site. If you execute this procedure on a a materialized view site, then the materialized view group owner must be PUBLIC.

See Also:

"COMMENT_ON_conflicttype_RESOLUTION Procedure" for instructions on placing a comment in the SCHEMA_COMMENT field of the DBA_REPGROUP view for a materialized view site if the materialized view group owner is not PUBLIC

< /a>

Syntax

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

Parameters

Table 18-43 COMMENT_ON_REPSITES Procedure Parameters

Exceptions

Table 18-44 COMMENT_ON_REPSITES Pr ocedure Exceptions

Parameter	Description
gname	Name of the replication group. This avoids confusion if a database is a master site in more than one replication environment.
master	The fully qualified database name of the master site on which you want to comm ent. If you are executing the procedure on a master site, then this parameter is required. To update comments at a materialized view site, omit this parameter. This parameter is optional.
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, then this pr ocedure updates the `MASTER_COMMENT` field of the `DBA_REPSITES` view. If the site is a materialized view site, then this procedure updates the `SCHEMA_COMMENT` field of the `DBA_REPGROUP` view.

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	Replication group does not exist.
commfailure	One or more master sites ar e not accessible.
corrupt	There is an inconsistency in the replication catalog vie ws.