Oracle7 Server Distributed Systems Volume II: Replicated Data

Updating Comments

There are several procedures in the DBMS_REPCAT package that allow you to update the comment information in the various views associated with replication. Table 7 - 1 lists the appropriate procedure to call for each view.

View DBMS_REPCAT Procedure Additional Information
RepGroup COMMENT_ON_REPGROUP( gname IN VARCHAR2, comment IN VARCHAR2) The parameters for the COMMENT_ON_REPGROUP procedure are described in Table 12 - 92, and the exceptions are listed in Table 12 - 93.
RepObject COMMENT_ON_REPOBJECT( sname IN VARCHAR2, oname IN VARCHAR2, type IN VARCHAR2, comment IN VARCHAR2) The parameters for the COMMENT_ON_REPOBJECT procedure are described in Table 12 - 96, and the exceptions are listed in Table 12 - 97.
RepSites COMMENT_ON_REPSITES( gname IN VARCHAR2, master IN VARCHAR, comment IN VARCHAR2) The parameters for the COMMENT_ON_REPSITES procedure are described in Table 12 - 94, and the exceptions are listed in Table 12 - 95.
RepColumn_Group COMMENT_ON_COLUMN_GROUP( sname IN VARCHAR2, oname IN VARCHAR2, column_group IN VARCHAR2, comment IN VARCHAR2) The parameters for the COMMENT_ON_COLUMN_GROUP procedure are described in Table 12 - 88, and the exceptions are listed in Table 12 - 89.
RepPriority_Group COMMENT_ON_PRIORITY_GROUP( gname IN VARCHAR2, pgroup IN VARCHAR2, comment IN VARCHAR2) The parameters for the COMMENT_ON_PRIORITY_GROUP procedure are described in Table 12 - 90, and the exceptions are listed in Table 12 - 91.

RepPriority_Group (site priority group) COMMENT_ON_SITE_PRIORITY( gname IN VARCHAR2, name IN VARCHAR2, comment IN VARCHAR2) The parameters for the COMMENT_ON_SITE_PRIORITY procedure are described in Table 12 - 90, and the exceptions are listed in Table 12 - 91.
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 Table 12 - 98, and the exceptions are listed in Table 12 - 99.
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 Table 12 - 98, and the exceptions are listed in Table 12 - 99.
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 Table 12 - 98, and the exceptions are listed in Table 12 - 99.

Table 7 - 1. Updating Comments in Symmetric Replication Facility Views

View	DBMS_REPCAT Procedure	Additional Information
RepGroup	`COMMENT_ON_REPGROUP( gname IN VARCHAR2, comment IN VARCHAR2)`	The parameters for the COMMENT_ON_REPGROUP procedure are described in Table 12 - 92, and the exceptions are listed in Table 12 - 93.
RepObject	`COMMENT_ON_REPOBJECT( sname IN VARCHAR2, oname IN VARCHAR2, type IN VARCHAR2, comment IN VARCHAR2)`	The parameters for the COMMENT_ON_REPOBJECT procedure are described in Table 12 - 96, and the exceptions are listed in Table 12 - 97.
RepSites	`COMMENT_ON_REPSITES( gname IN VARCHAR2, master IN VARCHAR, comment IN VARCHAR2)`	The parameters for the COMMENT_ON_REPSITES procedure are described in Table 12 - 94, and the exceptions are listed in Table 12 - 95.
RepColumn_Group	`COMMENT_ON_COLUMN_GROUP( sname IN VARCHAR2, oname IN VARCHAR2, column_group IN VARCHAR2, comment IN VARCHAR2)`	The parameters for the COMMENT_ON_COLUMN_GROUP procedure are described in Table 12 - 88, and the exceptions are listed in Table 12 - 89.
RepPriority_Group	`COMMENT_ON_PRIORITY_GROUP( gname IN VARCHAR2, pgroup IN VARCHAR2, comment IN VARCHAR2)`	The parameters for the COMMENT_ON_PRIORITY_GROUP procedure are described in Table 12 - 90, and the exceptions are listed in Table 12 - 91.
RepPriority_Group (site priority group)	`COMMENT_ON_SITE_PRIORITY( gname IN VARCHAR2, name IN VARCHAR2, comment IN VARCHAR2)`	The parameters for the COMMENT_ON_SITE_PRIORITY procedure are described in Table 12 - 90, and the exceptions are listed in Table 12 - 91.
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 Table 12 - 98, and the exceptions are listed in Table 12 - 99.
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 Table 12 - 98, and the exceptions are listed in Table 12 - 99.
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 Table 12 - 98, and the exceptions are listed in Table 12 - 99.