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-12231: TNS:No connection possible to destination

1 Answers  


QSM-01022: a more optimal materialized view than string was used to rewrite

1 Answers  


ORA-02839: Sync of blocks to disk failed.

1 Answers  


ORA-24157: duplicate variable name string

1 Answers  


PLS-00572: improper constraint form used

1 Answers   IBM,






ORA-25214: cannot specify delay or expiration for enqueue to exception queue

1 Answers  


ORA-07840: sllfop: LIB$GET_VM failure

1 Answers  


ORA-22853: invalid LOB storage option specification

1 Answers  


RMAN-08100: channel string: starting proxy validation

1 Answers  


ORA-06556: the pipe is empty, cannot fulfill the unpack_message request

1 Answers  


ORA-04930: open sequence number failed or initial state is valid

1 Answers  


LPX-00219: invalid digit '~c' in character reference

1 Answers  


Categories