Oracle Distributed Systems

DBMS_REPCAT: Performing Replication Administration

The DBMS_REPCAT package is the foundation of the replication API. It allows you to perform a wide variety of operations in several categories: advanced replication administration, snapshots, and conflict resolution.

How the Package Is Used

DBMS_REPCAT contains the procedures required to maintain the following aspects of a replicated environment:

• Site priority information

• Column group configuration

• Priority group configuration

• Conflict resolution techniques

• Snapshot propagation

• Object replication support

• Statistics

• Master site configuration

Installation and Access

The DBMS_REPCAT package is created when the Oracle database is installed. The dbmsrepc.sqlscript (found in the built-in packages source directory) contains the source code for this package’s specification. This script is called by catrep.sql, which must be run to install the advanced replication packages. The script creates the public synonym DBMS_REPCAT. The package procedure DBMS_REPCAT_AUTH.GRANT_SURROGATE_REPCAT grants EXECUTE privileges on the package to the specified grantee. In addition, the package owner (SYS) and users with the EXECUTE ANY PROCEDURE system privilege may execute it.

DBMS_REPCAT Procedures

Procedure Name	Description
ADD_conflicttype_RESOLUTION	Adds a custom conflict resolution handler for update, delete, or uniqueness conflicts.
ADD_GROUPED_COLUMN	Adds table column(s) to an existing column group.
ADD_MASTER_DATABASE	Adds a master database to a replication group. ...