Oracle Error QSM-01128: Multi MV rewrite is disabled

Oracle Error Message

QSM-01128: Multi MV rewrite is disabled

Reason for the Error

When multimv query rewrite is disabled, no multimv query rewrite will take place.

Solution

Enable multimv query rewrite with ALTER SESSION SET “_MULTIMV_QUERY_REWRITE_ENABLED” = true .