Oracle Distributed Systems

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