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

LPX-00108: parameter-entity parenthetical cannot be split up

ORA-25211: invalid DELAY specified when using sequence deviation

ORA-22606: pickler image handle [string] is not well-formed

ORA-09855: removeCallback: bad message format.

SQL-02138: No external procedure context exists

PCC-02138: CMD-LINE: Internal consistency error

ORA-08462: raw buffer contains invalid decimal data

RMAN-10004: unable to connect to recovery catalog

DRG-50917: escape on at end of text query string

SQL*Loader-00487: COUNT clause required for collection string

ORA-39753: unsupported use of subquery in PARTITIONED OUTER JOIN condition

NNL-00006: timeout, server is not responding

For more Oracle Errors Interview Questions Click Here