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

ORA-16627: No standby databases support the overall protection mode.

0 Answers   Oracle,


ORA-09889: osnTXtt: access error on oracle executable

1 Answers  


ORA-01613: instance string (thread string) only has string logs - at least 2 logs required to enable.

1 Answers  


ORA-25506: resource manager has not been continuously on in some instances

1 Answers  


ORA-19503: cannot obtain information on device, name="string", type="string", parms="string"

1 Answers  






PCC-02376: You may not declare SQLCODE when DEF_SQLCODE = TRUE

1 Answers  


LFI-00143: Unable to delete non-existent file string.

1 Answers  


ORA-02790: File name is too long

1 Answers  


SQL*Loader-00403: Referenced column string not present in table string.

1 Answers  


LSX-00240: bad float "~S"

1 Answers  


PCC-02102: Fatal error while doing C preprocessing

1 Answers  


ORA-09875: TASDEF_WRITE: write error when writing ?/dbs/tasdef@.dbf file.

1 Answers  


Categories