Oracle Error QSM-01131: query has ONLY_MULTIMV_REWRITE hint

Oracle Error Message

QSM-01131: query has ONLY_MULTIMV_REWRITE hint

Reason for the Error

When the query has this hint no multimv rewrite will be done if the query has a query block with no MVs in the from clause

Solution

Remove hint from query