Configuring 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 create a refresh group and add materialized views to it: 

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, click Create.

   The Create Refresh Group page appears, showing the General subpage.

7. Complete the following actions:

   • Enter a name for the refresh group in the Name field.

   • Enter the owner of the refresh group in the Schema field. Typically, the materialized view administrator owns refresh groups.

   • If necessary, then adjust the Next Date and Interval settings. The Next Date setting determines when the next refresh of the refresh group will occur. The Interval setting determines how often the refresh group is refreshed automatically. You can click Change to open a new page that adjusts each setting.

     If you have limited connectivity between the materialized view site and the master site, then you might want to refresh on demand. In this case, clear the Interval field.

   • Select Push changes from materialized views to master before refresh. This option specifies that, during refresh, the materialized view site pushes changes made to updatable materialized views to the master tables before refreshing the materialized views.

8. Click Materialized Views to open the Materialized Views subpage.

9. Click Add to open the Search and Select: Materialized View page.

10. Use the search tool to list the materialized views that you want to add to the refresh group.

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

12. Click OK to return to the Materialized Views subpage. The selected materialized views should be listed in the refresh group.

13. Click OK to create the refresh group.