Materialized Views

A 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. However, 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 simple, read-only and updatable materialized views.

• 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.