Oracle Error QSM-01007: query has NOREWRITE hint

Oracle Error Message

QSM-01007: query has NOREWRITE hint

Reason for the Error

When query contains a NOREWRITE hint, no query rewrite will take place for that query block.

Solution

Remove the NOREWRITE hint from the query