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-16214: apply stalled for apply delay

1 Answers  


TNS-02510: Invalid numeric data type

1 Answers  


ORA-32133: Cannot get stream from LOB/FILE

1 Answers  


ORA-29859: error occurred in the execution of ODCIINDEXTRUNCATE routine

1 Answers  


NID-00126: Database should have no datafiles in unknown state

1 Answers  






DRG-12422: write to client failed

1 Answers  


RMAN-04027: unable to write to a temporary file: "string"

1 Answers  


RMAN-06213: --------------- ---------------------------------------------------

1 Answers  


RMAN-06507: trying alternate file for archivelog thread number, sequence number

1 Answers  


QSM-00785: the directive string is not supported for task string at this time

1 Answers  


ORA-01985: cannot create user as LICENSE_MAX_USERS parameter exceeded

1 Answers  


ORA-30557: function based index could not be properly maintained

1 Answers  


Categories