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


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-13409: null or invalid pyramidLevel parameter

1 Answers  


ORA-27159: failure setting process scheduling priority

1 Answers  


ORA-19205: Attribute 'string' qualifies a non-scalar value in the select list

1 Answers  


ORA-33308: (DBVALID04) SEVERE ERROR: Record number used but not allocated

1 Answers  


ORA-25196: keyword MOVE in ALTER TABLE MOVE must immediately follow <table name>

1 Answers  






RMAN-08105: channel string: backup cancelled because no pieces were found

1 Answers  


ORA-01862: the numeric value does not match the length of the format item

1 Answers  


ORA-16029: cannot change LOG_ARCHIVE_MIN_SUCCEED_DEST, no archive log destinations

1 Answers  


DRG-13012: language column must be a char, varchar, or varchar2 type

1 Answers  


RMAN-06158: validation succeeded for archived log

1 Answers  


ORA-13023: interior element interacts with exterior element

1 Answers  


NNO-00118: line string: data length string exceeds maximum of string, data ignored

1 Answers  






Categories