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

PLS-00900: can't find body of unit 'string'

1 Answers  


ORA-00705: inconsistent state during start up; shut down the instance, then restart it

1 Answers  


ORA-13194: failed to decode supercell

1 Answers  


RMAN-06702: could not initialize for input file: "string"

1 Answers  


IMP-00071: Object identifier of imported table mismatches object identifier of existing table

1 Answers  






EXP-00093: Could not convert to server character set's handle

2 Answers  


ORA-23413: table "string"."string" does not have a materialized view log

1 Answers  


ORA-12156: TNS:tried to reset line from incorrect state

1 Answers  


ORA-24100: error in ktz testing layer

1 Answers  


ORA-30363: columns in a dimension column list must be in the same relation

1 Answers  


NZE-29047: Mismatch in Transport Layer Security extension

1 Answers  


ORA-31087: insufficient privileges to delete schema "string"

1 Answers  


Categories