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

The Replication Catalog

The replication catalog is the subset of the data dictionary that contains information about replicated objects at all master sites and, to a certain extent, snapshot sites. Operations that modify the data in the replication catalog, such as adding or removing master objects, must be propagated from the master definition site to other master sites. In general, changes to the replication catalog require that the affected replication group be quiesced. Just as Oracle maintains a deferred transaction queue (deftran) for queued transactions, it also maintains a queue for replication catalog changes, known as the repcatlog.

The 10 DBMS_REPCAT calls which create entries in the repcatlog queue are:

DBMS_REPCAT.ADD_MASTER_DATABASE
DBMS_REPCAT.ALTER_MASTER_PROPAGATION
DBMS_REPCAT.ALTER_MASTER_REPOBJECT
DBMS_REPCAT.CREATE_MASTER_REPOBJECT
DBMS_REPCAT.DROP_MASTER_REPGROUP
DBMS_REPCAT.DROP_MASTER_REPOBJECT
DBMS_REPCAT.EXECUTE_DDL
DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT
DBMS_REPCAT.RESUME_MASTER_ACTIVITY
DBMS_REPCAT.SUSPEND_MASTER_ACTIVITY

Replication Catalog Data Dictionary Views

The data dictionary views that make up the replication catalog are the following:

DBA_REPCAT

Name, status, and comment for every replication group. (Same as DBA_REPGROUP.)

DBA_REPCATLOG

Lists all items in the repcatlog queue.

DBA_REPDDL

Lists all DDL calls in the repcatlog queue.

DBA_REPGENERATED

Lists all replication support objects.

DBA_REPGROUP

Name, status, and comment for every replication group. (Same ...

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