Previous |
Next |
A materialized view contains a complete or partial copy of a table from a single point in time. In a replication environment, a materialized view is typically in a different database than the table on which it is based.
To view information about materialized views:
In Enterprise Manager, log in to the materialized view site as the materialized view administrator. The default user name for the materialized view administrator is mvadmin
.
Go to the Database Home page.
Click Data Movement to open the Data Movement subpage.
Click Manage in the Advanced Replication section.
The Advanced Replication: Administration page appears, showing the Overview subpage.
Click the number associated with Materialized Views in the Materialized View Site section to open the Materialized Views page.
Use the search tool to list the materialized views that you want to view. To list all materialized views, leave the Schema and Object Name fields blank and click Go.
The Materialized Views page contains important information about each materialized view listed, including its master table, master site (in the Master Link columns), and the last time it was refreshed.
For detailed information about a materialized view, select it and click View to open the View Materialized View page.
The View Materialized View page contains detailed information about the materialized view. The information is organized into the following sections: General, Refresh, Storage, Index Storage, Options, and Master Information.
Note: You can also query the ALL_MVIEWS
data dictionary view for information about materialized views.