QSM-01004: no query rewrite before view merging



QSM-01004: no query rewrite before view merging..

Answer / guest

Cause: Internal session parameter _QUERY_REWRITE_2 is set to
FALSE

Action: Change session parameter with ALTER SESSION command.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-32127: REFs do not belong to any connection

1 Answers  


NCR-01003: NCRS: Read error.

1 Answers  


ORA-00296: maximum number of files (string) exceeded for RECOVER DATAFILE LIST

1 Answers  


ORA-27084: unable to get/set file status flags

1 Answers  


ORA-00053: maximum number of enqueues exceeded

1 Answers  






DRG-12220: a valid tag must be provided

1 Answers  


DRG-10528: primary keys of type string are not allowed

1 Answers  


PCC-02019: Preprocessor warning at line number, column number, file string:

1 Answers  


ORA-32158: Invalid type passed

1 Answers  


ORA-00220: controlfile not mounted by first instance, check alert log for more info

1 Answers  


ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

1 Answers  


ORA-14106: LOGGING/NOLOGGING may not be specified for a clustered table

1 Answers  


Categories