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

Removing Materialized Views from a Refresh Group

To remove materialized views from a refresh group:

  1. In Enterprise Manager, connect to the Database Instance Home page as the replication administrator.

  2. Click Data Movement.

  3. Under the Advanced Replication section, click Manage. The Advanced Replication: Administration page appears.

  4. Under Materialized View Site section, click the number next to callbackRefresh Groups to open the Refresh Groups page.

  5. Select the target refresh group to which you want to add materialized view to and click Edit.

    The General subpage of the Edit Refresh Group page appears.

  6. Click Materialized Views.

  7. Select the materialized view that you want to remove from the refresh group.

  8. Click Remove.

  9. Click Apply.

Note: After you drop a materialized view from refresh group, Oracle no longer refreshes the materialized view automatically as part of the refresh group. To refresh the materialized view, you must add it to another refresh group or refresh it manually.

Related Topics

Managing Refresh Groups

Refresh Groups

What Is Materialized View Replication?