QSM-01002: no query rewrite when OPTIMIZER_MODE is rule based



QSM-01002: no query rewrite when OPTIMIZER_MODE is rule based..

Answer / guest

Cause: Query rewrite did not occur because the
OPTIMIZER_MODE was set to RULE.

Action: Change the optimizer mode using the OPTIMIZER_MODE
parameter.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-19767: missing TRACKING keyword

1 Answers  


IMG-00606: unable to access image data

1 Answers  


ORA-26501: RepAPI operation failure

1 Answers  


ORA-39082: Object type string created with compilation warnings

1 Answers  


ORA-24155: rule string.string not in rule set string.string

1 Answers  






ORA-28047: database is not a member of any enterprise domain in OID

1 Answers  


ORA-15051: file 'string' contains string error(s)

1 Answers  


ORA-27045: unable to close the file

1 Answers   Aomi,


NID-00138: Block verification failed for datafile string (number)

1 Answers  


ORA-16575: request terminated at broker discretion

1 Answers  


AMD-00120: dimension #string: analytic workspace dimension name not specified

1 Answers  


ORA-09853: snyRemovePort: bad return code from request.

1 Answers  


Categories