Database Error Messages

ORA-32440

Cannot create the materialized view ENABLE QUERY REWRITE if one or more inline views or named views of external tables are referenced

Cause

An attempt is being made to create the materialized view ENABLE QUERY REWRITE when one or more inline views or named views of external tables are referenced.


Action

Create the materialized view without using ENABLE QUERY REWRITE.