How to fix the Oracle error QSM-01026: query rewrite is disabled for, string?

In this post, you’ll learn more about the Oracle ErrorQSM-01026: query rewrite is disabled for, string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

QSM-01026: query rewrite is disabled for, string

Reason for the Error QSM-01026: query rewrite is disabled for, string

Query rewrite could not use this materialized view, because query rewrite was not enabled for it.

How to fix the Error QSM-01026: query rewrite is disabled for, string ?

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

Enable query rewrite for the materialized view with ALTER MATERIALIZED VIEW “mv” ENABLE QUERY REWRITE command, where “mv” is the name of the materializev view.