This illustration shows objects used in materialized view replication.
The Master Database contains the following objects:
- Materialized view log (optional)
- Trigger for materialized view log (optional)
- Master table (always required)
The Master Materialized View Database contains the following objects:
- Master materialized view (always required)
- Index (always required)
- Materialized view log (optional)
- Trigger for materialized view log (optional)
- Updatable materialized view log (updatable materialized views only)
- Trigger for updatable materialized view log (updatable materialized views only)
The Materialized View Database contains the following objects:
- Materialized view (always required)
- Index (always required)
- Updatable materialized view log (updatable mateialized views only)
- Trigger for updatable materialized view log (updatable materialized views only)