Managing Materialized Views

A table materialized view is a local copy of table data that originates from one or more remote master tables. Applications can query the data in a read-only table materialized view, but cannot insert, update, or delete rows in the materialized view. Conversely, applications can query, insert, update, or delete the rows in an updatable materialized view.

Oracle's data replication facility supports independent table materialized views as well as materialized views that are part of a materialized view group. Consider the following issues when deciding whether to create a new materialized view as part of a materialized view group.

• A materialized view group can contain updatable materialized views

• A materialized view group can contain read-only materialized views based on a single master table. Typically, however, read-only materialized views are not in materialized view groups.

• A materialized view group does not support complex read-only materialized views. Oracle creates all complex read-only materialized views independent of any materialized view group.

Oracle Enterprise Manager has many features that help you create and manage materialized views in a replication environment.

To learn more about managing materialized views, follow a link:

• Creating a Materialized View

• Editing a Materialized View

• Manually Refreshing a Materialized View

• Viewing Materialized View Data Dictionary Views

• Removing a Materialized View