Manage Replicated Environment with APIs, 9 of 9

Updating the Comments Fields in Data Dictionary Views

Several procedures in the DBMS_REPCAT package let you update the comment information in the various data dictionary views associated with replication. Table 7-1 lists the appropriate procedure to call for each view.

Table 7-1 Updating Comments in Advanced Replication Facility Views

View	DBMS_REPCAT Procedure	See for Parameter Information
DBA_REPGROUP	COMMENT_ON_REPGROUP( gname IN VARCHAR2, Comment IN VARCHAR2)	COMMENT_ON_REPGROUP procedure .
DBA_REPOBJECT	COMMENT_ON_REPOBJECT( sname IN VARCHAR2, oname IN VARCHAR2, type IN VARCHAR2, comment IN VARCHAR2)	COMMENT_ON_REPOBJECT procedure .
DBA_REPSITES	COMMENT_ON_REPSITES( gname IN VARCHAR2, master IN VARCHAR, comment IN VARCHAR2)	COMMENT_ON_REPSITES procedure .
DBA_REPCOLUMN_ GROUP	COMMENT_ON_COLUMN_GROUP( sname IN VARCHAR2, oname IN VARCHAR2, column_group IN VARCHAR2, comment IN VARCHAR2)	COMMENT_ON_COLUMN_GROUP procedure .
DBA_REPPRIORITY_ GROUP	COMMENT_ON_PRIORITY_GROUP( gname IN VARCHAR2, pgroup IN VARCHAR2) comment IN VARCHAR2)	COMMENT_ON_PRIORITY_GROUP/COMMENT_ON_SITE_PRIORITY procedures .
DBA_REPPRIORITY_ GROUP (site priority group)	COMMENT_ON_SITE_PRIORITY( gname IN VARCHAR2, name IN VARCHAR2, comment IN VARCHAR2)	COMMENT_ON_PRIORITY_GROUP/COMMENT_ON_SITE_PRIORITY procedures .
DBA_REPRESOLUTION (uniqueness conflicts)	COMMENT_ON_UNIQUE_RESOLUTION( sname IN VARCHAR2, oname IN VARCHAR2, constraint_name IN VARCHAR2, sequence_no IN NUMBER, Comment IN VARCHAR2)	The parameters for the COMMENT_ON_UNIQUE_RESOLUTION procedures are described in COMMENT_ON_conflicttype_RESOLUTION procedure .
DBA_REPRESOLUTION (update conflicts)	COMMENT_ON_UPDATE_RESOLUTION( sname IN VARCHAR2, oname IN VARCHAR2, column_group IN VARCHAR2, sequence_no IN NUMBER, Comment IN VARCHAR2)	The parameters for the COMMENT_ON_UNIQUE_RESOLUTION procedures are described in COMMENT_ON_conflicttype_RESOLUTION procedure .
DBA_REPRESOLUTION (delete conflicts)	COMMENT_ON_DELETE_RESOLUTION( sname IN VARCHAR2, oname IN VARCHAR2, sequence_no IN NUMBER, comment IN VARCHAR2)	The parameters for the COMMENT_ON_UNIQUE_RESOLUTION procedures are described in COMMENT_ON_conflicttype_RESOLUTION procedure .