Site Priority Groups with DBMS_REPCAT
The site priority group technique resolves conflicts by accepting the data that originated from the site with the highest priority.
About Site Priority Groups
The procedures for creating and maintaining site priority groups are almost completely analogous to those used for priority groups. The similarity arises because a site priority group is actually a special case of a priority group in which the range of data values is the range of global names in the replicated environment. In fact, Oracle stores the information about priority groups and site priority groups in the same data dictionary views (DBA_REPPRIORITY_GROUP and DBA_REPPRIORITY). However, unlike in the priority group technique, you should base site priority group rankings on your confidence in the data from each site, as opposed to the business rules associated with a workflow.
Use the following programs to maintain site priority groups:
| DBMS_REPCAT.ADD_SITE_PRIORITY_SITE |
| DBMS_REPCAT.ALTER_SITE_PRIORITY |
| DBMS_REPCAT.ALTER_SITE_PRIORITY_SITE |
| DBMS_REPCAT.COMMENT_ON_SITE_PRIORITY |
| DBMS_REPCAT.DEFINE_SITE_PRIORITY |
| DBMS_REPCAT.DROP_SITE_PRIORITY |
| DBMS_REPCAT.DROP_SITE_PRIORITY_SITE |
Creating, Maintaining, and Dropping Site Priorities
DBMS_REPCAT’s DEFINE_SITE_PRIORITY and DROP_SITE_PRIORITY procedures allow you to create and drop site priorities. Use the COMMENT_ON_SITE_PRIORITY procedure to maintain the comment on the site priority.
The DBMS_REPCAT.DEFINE_SITE_PRIORITY procedure
The DEFINE_SITE_PRIORITY ...
Get Oracle Built-in Packages now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
