Refreshing a Materialized View

Refreshing a materialized view makes it consistent with its master table. If the materialized view is part of a refresh group, then it is usually best to refresh the refresh group instead of the materialized view individually. Refreshing the refresh group ensures that all of the materialized views in the refresh group are consistent to a point in time.

To refresh a materialized view: 

1. 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.

2. Go to the Database Home page.

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

4. Click Manage in the Advanced Replication section.

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

5. Click the number associated with Materialized Views in the Materialized View Site section.

6. On the Materialized Views page, use the search tool to list the materialized view that you want to refresh.

   To list all materialized views, leave the Schema and Object Name fields blank and click Go.

7. Select the materialized view in the list.

8. Select Refresh in the Actions list.

9. Click Go to open the Refresh Materialized View page for the selected materialized view.

10. Adjust the options if necessary.

    Typically, the default values should be used.

11. Click OK.

12. On the confirmation page, click Yes to refresh the materialized view.