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

DRG-13305: 'off' attribute value must be in the range string..string, at line string

1 Answers  


ORA-09925: Unable to create audit trail file

1 Answers  


ORA-39311: illegal clone_recovery() call: it only applys to failed clones

1 Answers  


ORA-30150: Invalid argument passed to OCIFile function

1 Answers  


NNL-01066: Statistic counter logging interval: string

1 Answers  






NNL-00899: OK responses sent: number

1 Answers  


TNS-12206: TNS:received a TNS error during navigation

1 Answers  


QSM-00761: the priority string is invalid for the current operation

1 Answers  


ORA-01291: missing logfile

1 Answers  


ORA-02184: resource quotas are not allowed in REVOKE

1 Answers  


TNS-04020: CMCTL Version: number.number.number.number.number

1 Answers  


ORA-00450: background process 'string' did not start

1 Answers  


Categories