Removing a Materialized View Group

To remove a materialized view group:

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

Make sure you are connected to the materialized view site as the materialized view administrator (typically MVADMIN user) or the replication administrator (typically REPADMIN user).
Click Data Movement.
Under the Advanced Replication section, click Manage. The Advanced Replication: Administration page appears.
Under the Materialized View Site section, click the number next to Materialized View Groups.

The Materialized View Groups page appears.
Select the materialized view group that you want to remove.
Click Delete.
On the Confirmation page, click Yes to confirm that you want to remove the selected materialized view group.
Enable the Drop all objects in the group option if you want to drop all of the objects in the materialized view group from the materialized view database.

Do not enable this option if you want to drop the materialized view group but also want to keep the objects in the group in the materialized view database.
Click OK to complete the delete operation.

Note: When you drop a materialized view group, you can also decide whether to drop the group's objects from the database. If you choose not to drop a group's objects when you drop the group, the objects remain in the database at the materialized view site.

Materialized Views that remain after dropping the corresponding materialized view group persist as ungrouped materialized views and are refreshed as long as they remain in a refresh group. However, Oracle does not propagate any changes made to an updatable materialized view to its master site.

API EQUIVALENT: DBMS_REPCAT.DROP_SNAPSHOT_REPGROUP

Removing a Materialized View Group

Related Topics