Oracle Error Message
ORA-32340: cannot tune the materialized view definition
Reason for the Error
Due to constructs in the materialized view definition, it could not be tuned to be fast-refreshable or rewriteable.
Solution
Execute DBMS_MVIEW.EXPLAIN_MVIEW to determine the cause.