QSM-01007: query has NOREWRITE hint



QSM-01007: query has NOREWRITE hint..

Answer / guest

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

Action: Remove the NOREWRITE hint from the query

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-00023: session references process private memory; cannot detach session

2 Answers  


LPX-00276: bad HTTP/Mime header

1 Answers  


NZE-29164: External PKCS #12 wallet is not supported in FIPS mode.

1 Answers  


PLS-00996: out of memory

1 Answers  


TNS-00536: Connection entered inappropriate state

1 Answers  






PROC-00012: Out of heap memory.

1 Answers  


LCD-00201: could not open specified filename [string]

1 Answers  


DRG-10595: ALTER INDEX string failed

1 Answers  


SQL*Loader-00465: %s directive expects number arguments, number found.

1 Answers  


ORA-25321: enqueue failed, user property specified but queue string.string is not an 8.1 style queue

1 Answers  


EXP-00034: error on rowid: file# number block# number slot# number

1 Answers  


NNL-00221: Statistic counter logging interval is now string

1 Answers  


Categories