Oracle Error QSM-01001: query rewrite not enabled

Oracle Error Message

QSM-01001: query rewrite not enabled

Reason for the Error

When query rewrite is disabled, no query rewrite will take place.

Solution

Enable query rewrite with ALTER SESSION SET QUERY_REWRITE ENABLE command.