What Are The Limitations Of Materialized Views?

1.	What Are The Limitations Of Materialized Views?
Answer» You cannot INSERT, update, delete or truncate a MATERIALIZED view. Any CHANGES on the base tables will REFLECT into materialized views. You can specify only one base table in the from clause. Base table can’t be a external table, system table or a temporary table. You cannot use a where clause in the materialized view. Expressions are not allowed as columns.

Answer»

You cannot INSERT, update, delete or truncate a MATERIALIZED view. Any CHANGES on the base tables will REFLECT into materialized views.
You can specify only one base table in the from clause.
Base table can’t be a external table, system table or a temporary table.
You cannot use a where clause in the materialized view.
Expressions are not allowed as columns.

Discussion