Oracle Error QSM-03118: Cannot tune the materialized view for general rewrite

Oracle Error Message

QSM-03118: Cannot tune the materialized view for general rewrite

Reason for the Error

The materialized view could not be tuned for supporting general rewrite.

Solution

Run the dbms_mview.explain_mview to find out the reason.