Your browser does not support JavaScript. This help page requires JavaScript to render correctly.
Skip Headers
Previous
Previous
 
Next
Next

Refreshing a Refresh Group

When you refresh a refresh group, all of the materialized views in the refresh group are refreshed to a consistent point in time.

To refresh a refresh group: 

  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 callbackRefresh Groups in the Materialized View Site section.

  6. On the Refresh Groups page, use the search tool to list the refresh group that you want to refresh.

  7. Select the refresh group in the list.

  8. Click Edit.

    The Edit Refresh Group page appears, showing the General subpage.

  9. Click Refresh Now in the Refresh section.

Note: You can also use the following procedures in the DBMS_REFRESH.REFRESH procedure to refresh a refresh group.

Related Topics

About Materialized View Refresh

About Refresh Groups

Configuring a Refresh Group

Viewing Information About Refresh Groups

Refreshing Materialized Views