Removing a Refresh Group

To delete 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 that you want to delete.
Click Delete.
On the Confirmation page, click Yes to confirm the deletion.

Note: After you drop a refresh group, Oracle no longer refreshes the group's orphaned materialized views automatically. To refresh the materialized views, you must add them to another materialized view refresh group or refresh them manually.

Removing a Refresh Group

Related Topics