In this post, you’ll learn more about the Oracle ErrorQSM-01202: query rewrite not possible when OPTIMIZER_MODE is set to rule based with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
QSM-01202: query rewrite not possible when OPTIMIZER_MODE is set to rule based
Reason for the Error QSM-01202: query rewrite not possible when OPTIMIZER_MODE is set to rule based
Query rewrite did not occur because the OPTIMIZER_MODE was set to RULE.
How to fix the Error QSM-01202: query rewrite not possible when OPTIMIZER_MODE is set to rule based ?
You can fix this error in Oracle by following the below steps
Change the optimizer mode using the OPTIMIZER_MODE parameter.