Viewing Information About Materialized View Groups

Materialized view groups make it easy to manage materialized views that are logically related. For example, you might add all of the materialized views in a schema or all of the materialized views used by an application to a materialized view group. Also, for materialized views to be updatable, they must belong to a materialized view group.

To view information about the materialized view groups at a materialized view site: 

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 Materialized View Groups in the Materialized View Site section.

   The Materialized View Groups page appears, listing the names of the materialized view groups at the materialized view site.

6. To view detailed information about a materialized view group, click the name of the materialized view group to open the View Materialized View Group page.

The View Materialized View Group page includes the following information:

• In the Link To Master field, the name of the database link to the master site. The master site contains the master tables of the materialized views in the materialized view group.

• In the Propagation Mode field, Asynchronous is displayed because the propagation sends messages according to a propagation schedule.

• In the Description field, a description of the materialized view group if the group has a description.

• In the Objects section, a list of the database objects in the materialized view group and information about each database object