Adding Materialized Views to a Refresh Group

When two or more materialized views must be consistent to a point in time, the materialized views should belong to the same refresh group.

To add materialized views to a refresh group: 

1. In Enterprise Manager, log in to the materialized view site as the materialized view administrator. The default user name for the materialized view administrator is mvadmin.

2. Go to the Database Home page.

3. Click Data Movement to open the Data Movement subpage.

4. Click Manage in the Advanced Replication section.

   The Advanced Replication: Administration page appears, showing the Overview subpage.

5. Click the number associated with Refresh Groups in the Materialized View Site section.

6. On the Refresh Groups page, use the search tool to list the refresh group that you want to modify.

7. Select the refresh group.

8. Click Edit.

9. On the Edit Refresh Group page, click Materialized Views.

10. On the Materialized Views subpage, click Add.

11. On the Search and Select: Materialized View page, use the search tool to list the materialized views that you want to add to the refresh group.

12. Select the materialized views that you want to add to the refresh group.

13. Click OK.

14. On the Edit Refresh Group page, click Apply to finish adding the materialized views to the refresh group.