Previous |
Next |
To create a new refresh group (as described in Refresh Groups)for a materialized view site:
In Enterprise Manager, connect to the Database Instance Home page as the replication administrator.
Click Data Movement.
Under the Advanced Replication section, click Manage. The Advanced Replication: Administration page appears.
Under Materialized View Site section, click the number next to Refresh Groups to open the Refresh Groups page.
On the Refresh Groups page, click Create.
The General subpage of the Create Refresh Group page appears.
The Create Refresh Group page has two tabs: General and Materialized Views.
The General subpage lets you specify the name and owner for the group.
The Materialized Views subpage lets you add materialized views to the refresh group.
Click Help in the dialog box for more information.
Note: To refresh a materialized view, the user account of the database link used by the materialized view must have SELECT privileges on the master base table and, for fast refreshes, on the corresponding materialized view log.