You cannot insert, update, delete, or truncate a materialized view. Any changes on the base tables will reflect materialized views.
You can specify only one base table in the from clause.
The base table can’t be an external table, a system table, or a temporary table.
You cannot use a where clause in the materialized view.
Expressions are not allowed as columns.
