Oracle® Database Advanced Replication Management API Reference 10g Release 1 (10.1) Part Number B10733-01 |
|
|
View PDF |
When you install replication capabilities at a site, Oracle installs the replication catalog, which consists of tables and views, at that site.
This chapter contains this topic:
Caution: Do not modify the replication catalog tables directly. Instead, use the procedures provided in the |
Many data dictionary tables have three corresponding views:
ALL_
view displays all the information accessible to the current user, including information from the current user's schema as well as information from objects in other schemas, if the current user has access to those objects by way of grants of privileges or roles.DBA_
view displays all relevant information in the entire database. DBA_
views are intended only for administrators. They can be accessed only by users with the SELECT
ANY
TABLE
privilege. This privilege is assigned to the DBA role when Oracle is initially installed.USER_
view displays all the information from the schema of the current user. No special privileges are required to query these views.The columns of the ALL_
, DBA_
, and USER_
views corresponding to a single data dictionary table are usually nearly identical. Therefore, these views are described in full only once in this chapter (for the ALL_
view). The views are listed without the full description for DBA_
and USER_
views, but differences are noted.
As shown in Figure 23-1, the replication catalog views are used by master sites and materialized view sites to determine such information as what objects are being replicated, where they are being replicated, and if any errors have occurred during replication. Table 23-1 lists all of the replication catalog views.
Text description of the illustration repma002.gif
ALL_ Views | DBA_ Views | USER_ Views |
---|---|---|
- |
- | |
- |
- | |
- |
- |