Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-09700: sclin: maximum number of latches exceeded

1 Answers  


ORA-07501: scgtoa: $deq unexpected return

1 Answers  


ORA-06804: TLI Driver: could not bind an IPX address at initialization

1 Answers  


PLS-00732: Illegal overload of ellipsis in formal parameter list

1 Answers  


ORA-31453: invalid value string for parameter, expecting: Y, N, or NULL

1 Answers  






ORA-25244: dequeue index key not found, QUEUE string, rowid string

1 Answers  


DRG-13010: alt_value is already used by another sub lexer

1 Answers  


QSM-01040: match between the materialized view (string) and query join graphs failed

1 Answers  


PLS-00124: name of exception expected for first arg in exception_init pragma

1 Answers  


IMP-00034: Warning: FromUser "string" not found in export file

1 Answers  


NNO-00629: warning: invalid forwarder list, no default forwarders loaded

1 Answers  


NZE-28826: invalid cryptographic engine function passed

1 Answers  






Categories