Removing a Materialized View

To remove a materialized view:

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 Materialized Views to open the Materialized Views page.

5. Select the materialized view you want to remove and click Delete.

   The Confirmation page appears.

6. Click Yes to confirm the deletion.