QSM-01131: query has ONLY_MULTIMV_REWRITE hint



QSM-01131: query has ONLY_MULTIMV_REWRITE hint..

Answer / guest

Cause: WHen the query has this hint no multimv rewrite will
be done if the query has a query block with no MVs in the
from clause

Action: Remove hint from query

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-22971: invalid datatype for PRIMARY KEY-based object identifier

1 Answers  


PCB-00204: Group items cannot be used except in INTO or VALUES clause

1 Answers  


NNC-00400: memory exhausted

1 Answers  


LPX-00300: no name in attribute set

1 Answers  


ORA-22921: length of input buffer is smaller than amount requested

1 Answers  






ORA-29884: domain index is defined on the column to be dropped

1 Answers  


AMD-00151: Creation of Custom Measure "string" in Workspace "string" failed

1 Answers  


ORA-16168: LGWR network server could not switch to blocking mode

1 Answers  


RMAN-20004: target database name does not match name in recovery catalog

1 Answers  


ORA-38442: The ADT "string" is not in a valid state.

1 Answers  


TNS-00207: Uptime : number days number hr. number min. number sec

1 Answers  


NNL-00855: Slowest rename processing time: string

1 Answers  


Categories