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:
The data dictionary views that make up the replication catalog are the following:
Name, status, and comment for every replication group. (Same as DBA_REPGROUP.)
Lists all items in the repcatlog queue.
Lists all DDL calls in the repcatlog queue.
Lists all replication support objects.
Name, status, and comment for every replication group. (Same ...