Oracle Error QSM-01002: no query rewrite when OPTIMIZER_MODE is rule based

Oracle Error Message

QSM-01002: no query rewrite when OPTIMIZER_MODE is rule based

Reason for the Error

Query rewrite did not occur because the OPTIMIZER_MODE was set to RULE.

Solution

Change the optimizer mode using the OPTIMIZER_MODE parameter.