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)