Oracle7 Server Distributed Systems Volume II: Replicated Data

Listing Information about a Replicated Environment

Whenever you install symmetric replication capabilities at a site, Oracle installs the replication catalog, which consists of tables and views. These tables are used by master and snapshot sites to determine such information as what objects are being replicated, where they are being replicated, and if any errors have occurred while administering replication.

Warning: Do not modify the replication catalog tables directly. All modification should be made to replication catalog views by using the procedures provided in the DBMS_REPCAT package.

Each of these views is briefly described below. They are described in more detail in Chapter 13.

Each view has three versions, which have different prefixes: USER_*, ALL_*, and SYS.DBA_*. The views used to determine the status of the objects in your replication environment are as follows:

RepGroup Indicates which schemas are being replicated at a given site.
RepSite Indicates where each object group is being replicated
RepObject indicates which objects in each schema are being replicated.
RepCatLog Indicates the status of any asynchronously propagated administrative changes.

RepGroup	Indicates which schemas are being replicated at a given site.
RepSite	Indicates where each object group is being replicated
RepObject	indicates which objects in each schema are being replicated.
RepCatLog	Indicates the status of any asynchronously propagated administrative changes.