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

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

Question Posted / guest

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

More Oracle Errors Interview Questions

EXP-00084: Unexpected DbmsJava error number at step number

ORA-37008: (AWLISTALL06) number writers

ORA-15040: diskgroup is incomplete

ORA-22632: AnyDataSet parameter is not valid for the current operation

ORA-14506: LOCAL option required for partitioned indexes

NCR-03002: NCRO: Maximum number of contexts has been reached

ORA-00313: open failed for members of log group string of thread string

NNO-00607: server will forward to default forwarders only

PLS-00246: PARAMETER STYLE is unsupported

ORA-08179: concurrency check failed

ORA-09370: Windows 3.1 Two-Task driver ORACLE task timed out

O2F-00306: Unable to close the INTYPE file

For more Oracle Errors Interview Questions Click Here