QSM-01047: complex join back on non-MAV rewrite not allowed
(string)



QSM-01047: complex join back on non-MAV rewrite not allowed (string)..

Answer / guest

Cause: Query Rewrite can occur by means of a complex join
back only during a MAV rewrite.

Action: none

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

LSX-00344: namespace values "~1S" and "~2S" differ

1 Answers  


SQL*Loader-00121: Invalid skip_unusable_indexes option

1 Answers  


RMAN-00552: syntax error in command line arguments

1 Answers  


ORA-01158: database string already mounted

1 Answers  


IMG-00844: internal image data allocation failed

1 Answers  






ORA-01923: CASCADE aborted, objects locked by another user

1 Answers  


ORA-06919: CMX: error during write request (unknown event)

1 Answers  


NNC-00005: cannot initialization stream subsystem

1 Answers  


NNF-00110: no values exist

1 Answers  


ORA-01262: Stat failed on a file destination directory

1 Answers  


ORA-32032: free temporary object number not available

1 Answers  


PLS-00624: USING clause must be used with either aggregate or pipelined functions

1 Answers  


Categories