This illustration shows the orders master table and the following materialized views:
The level 1 materialized view orders_1 is the master of the orders_2 materialized 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.