Adding Materialized Views to a Refresh Group

To add materialized views to a refresh group:

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 Refresh Groups to open the Refresh Groups page.

5. Select the target refresh group to which you want to add materialized view to and click Edit.

   The General subpage of the Edit Refresh Group page appears.

6. Click Materialized Views.

7. Click Add.

   The Add Materialized View(s) to Refresh Group dialog box appears.

   Click Help for more information about the controls in the page.

8. In the Schema field, enter the name of the schema that contains the materialized view you want to add.

9. Click Go.

   All the available materialized views in the schema are displayed in the Results section.

10. Select the materialized views that you want to add from the Materialized View list.

11. Click OK when you have completed selecting the materialized views to add to the refresh group.

12. Click Apply when you have made all of the necessary refresh scheduling modifications.