Viewing Materialized View Logs at a Master Site

Materialized view logs keep track of changes to master tables so that a fast refresh of materialized views is possible.

To view information about the materialized view logs at a master site: 

1. In Enterprise Manager, log in to the master site as an administrative user, such as the replication administrator or SYSTEM. By default, the user name of the replication administrator is repadmin.

2. Click Data Movement to open the Data Movement subpage.

3. Click Manage in the Advanced Replication section.

   The Advanced Replication: Administration page appears, showing the Overview subpage.

4. Click the number associated with Materialized View Logs in the Master Site section.

   The Materialized View Logs page appears.

5. Use the search tool to list the materialized view logs that you want to view.

   To list all materialized view logs, ensure that the Schema and Object Name fields are blank, and click Go.

   The Materialized View Logs page lists the schema, underlying log table, and master table for each materialized view log listed.

6. For detailed information about a materialized view log, select it and click View to open the View Materialized View Log page.

The View Materialized View Log page contains detailed information about the materialized view log. The information is organized into the following sections: General, Options, and Storage.