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 .