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.