QSM-01128: Multi MV rewrite is disabled



QSM-01128: Multi MV rewrite is disabled..

Answer / guest

Cause: When multimv query rewrite is disabled, no multimv
query rewrite will take place.

Action: Enable multimv query rewrite with ALTER SESSION SET
"_MULTIMV_QUERY_REWRITE_ENABLED" = true .

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PLS-00496: too few columns in SELECT...INTO statement after bursting record targets

1 Answers  


ORA-02240: invalid value for OBJNO or TABNO

1 Answers  


LPX-00662: Invalid encoding.

1 Answers  


ORA-12657: No algorithms installed

1 Answers  


ORA-39316: illegal clean_up() call: last clone operation is failed

1 Answers  






ORA-13195: failed to generate maximum tile value

1 Answers  


ORA-08119: The new initrans will make the index too big

1 Answers  


LPX-00221: the character "<" cannot occur in attribute values

1 Answers  


RMAN-06085: must use SET NEWNAME command to restore datafile string

1 Answers  


ORA-22064: invalid NLS parameter string [string]

1 Answers  


ORA-13863: Statistics aggregation for service(module/action) string is not enabled

1 Answers  


ORA-19960: Internal use only

1 Answers  


Categories