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.