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-28028: could not authenticate remote server

1 Answers  


ORA-12509: TNS:listener failed to redirect client to service handler

1 Answers  


ORA-02035: illegal bundled operation combination

1 Answers  


SQL*Loader-00532: OCI return status: continue

1 Answers  


ORA-23539: table "string"."string" currently being redefined

1 Answers  






RMAN-06062: can not backup SPFILE because the instance was not started with SPFILE

1 Answers  


ORA-16774: Error in stopping the physical apply service (MRP process)

1 Answers  


RMAN-06485: changed archivelog expired

1 Answers  


UDE-00051: unable to set NLS_NUMERIC_CHARACTERS to required defaults.

1 Answers  


IMG-00531: empty or null image processing command

1 Answers  


ORA-38471: ROWIDs for table aliases cannot be null

1 Answers  


QSM-00517: Summary Advisor requires a COMPATIBLE setting of 8.1.0.0 or greater

1 Answers  


Categories