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.
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
Object replication support
Master site configuration
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.
Adds a custom conflict resolution handler for update, delete, or uniqueness conflicts.
Adds table column(s) to an existing column group.
Adds a master database to a replication group. ...