Removing Objects from a Materialized View Group

To remove objects from a materialized view group:

1. 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).

2. Click Data Movement.

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

4. Under the Materialized View Site section, click the number next to Materialized View Groups.

   The Materialized View Groups page appears.

5. Click Edit.

   The Edit Materialized View Group page appears.

6. From the Object Name list, select the master group object that you want to remove from your materialized view group.

7. Click Remove.

8. Click Apply.