Illustration repln097.gif shows the orders master table and the following materialized views:
- The level 1 materialized view orders_1 is the master of the orders_2 materialzied view.
- The level 2 materialized view orders_2 is the master of the orders_3 materialized view.
- The level 3 materialized view orders_3 is not a master.
The master table and the materialized views all contain the same data.