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

Oracle Error Message

QSM-01026: query rewrite is disabled for, string

Reason for the Error

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

Solution

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.