O'Reilly logo

Oracle Distributed Systems by Charles Dye

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required