Previous |
Next |
To remove materialized views from a refresh group:
In Enterprise Manager, connect to the Database Instance Home page as the replication administrator.
Click Data Movement.
Under the Advanced Replication section, click Manage. The Advanced Replication: Administration page appears.
Under Materialized View Site section, click the number next to Refresh Groups to open the Refresh Groups page.
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.
Click Materialized Views.
Select the materialized view that you want to remove from the refresh group.
Click Remove.
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.