Part VIII Managing Read-Only Materialized Views
Read-only materialized views can provide read-only access to the master table's data. You can create and manage read-only materialized views.
- Read-Only Materialized View Concepts
Understand the concepts related to read-only materialized views.
- Read-Only Materialized View Architecture
Several objects are used in materialized view replication. Some of these objects are optional and are used only as needed to support the created materialized view environment. For example, if you have a complex materialized view that cannot be fast refreshed, then you might not have a materialized view log at the master database.
- Planning for Read-Only Materialized Views
Before you begin to plan your read-only materialized view environment, it is important to understand the concepts and architecture related to materialized views. After you understand concepts and architecture of read-only materialized views, there are important considerations for planning a read-only materialized view environment.
- Creating and Managing Read-Only Materialized Views
You can create and manage read-only materialized views and refresh groups. You can also refresh materialized views.
- Troubleshooting Problems with Read-Only Materialized Views
You can diagnose and solve problems with database links, materialized view creation, and materialized view refresh.