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

NNL-00918: Time until server restart: string

1 Answers  


TNS-00508: No such protocol adapter

1 Answers  


ORA-07446: sdnfy: bad value 'string' for parameter string.

1 Answers  


CLSR-00501: Error number encountered when connecting to EVM daemon

1 Answers  


TNS-00557: unsupported wallet retrieval method

1 Answers  






TNS-00035: INTCTL: error while constructing full file name

1 Answers  


ORA-02025: all tables in the SQL statement must be at the remote database

1 Answers  


SQL*Loader-00800: %s specified and ignored

1 Answers  


RMAN-06486: changed backup piece expired

1 Answers  


ORA-07419: sfareq: Database writer got error in timing function.

1 Answers  


CLSS-00001: skgxn not active

1 Answers  


DRG-52210: error while registering value for attribute: string

1 Answers  


Categories