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.