How to fix the Oracle error QSM-01130: Multi MV rewrite not allowed if at least one query block has no MVs?

In this post, you’ll learn more about the Oracle ErrorQSM-01130: Multi MV rewrite not allowed if at least one query block has no MVs with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

QSM-01130: Multi MV rewrite not allowed if at least one query block has no MVs

Reason for the Error QSM-01130: Multi MV rewrite not allowed if at least one query block has no MVs

When only multimv query rewrite is enabled, every query block should have at least one MV in it’s from clause

How to fix the Error QSM-01130: Multi MV rewrite not allowed if at least one query block has no MVs ?

You can fix this error in Oracle by following the below steps

Disable only multimv query rewrite with ALTER SESSION SET “_ONLY_MULTIMV_QUERY_REWRITE_ENABLED” = false .