QSM-01130: Multi MV rewrite not allowed if at least one
query block has no MVs



QSM-01130: Multi MV rewrite not allowed if at least one query block has no MVs..

Answer / guest

Cause: When only multimv query rewrite is enabled, every
query block should have at least one MV in it's from clause

Action: Disable only multimv query rewrite with ALTER
SESSION SET "_ONLY_MULTIMV_QUERY_REWRITE_ENABLED" = false .

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-19320: Host name not specified in HTTP URL

1 Answers  


ORA-25443: duplicate column value for table alias: string, column number: string

1 Answers  


QSM-00999: Advisor feature is not currently implemented

1 Answers  


ORA-24359: OCIDefineObject not invoked for a Object type or Reference

1 Answers  


PLS-00664: Both ORDER BY and CLUSTER BY can not be specified for the same table function

1 Answers  






ORA-01949: ROLE keyword expected

1 Answers  


ORA-10652: Object has on-commit materialized views

1 Answers  


NZE-29238: the cryptographic engine could not apply the algorithm

1 Answers  


LPX-00319: The node specified is not valid

1 Answers  


PLS-00128: Illegal number of arguments for pragma string

1 Answers  


ORA-01915: invalid auditing option for views

1 Answers  


ORA-13349: polygon boundary crosses itself

1 Answers  


Categories