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
QSM-01007: query has NOREWRITE hint
When query contains a NOREWRITE hint, no query rewrite will take place for that query block.
Remove the NOREWRITE hint from the query