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

ORA-02327: cannot create index on expression with datatype string

ORA-30656: column type not supported on external organized table

NNL-00301: Server shutting down

SQL*Loader-00952: Error calling once/data file initialization

QSM-01065: materialized view, string, cannot compute measure, string, in the query

NPL-00418: received malformed ASN.1 object identifier

ORA-01514: error in log specification: no such log

ORA-02227: invalid cluster name

DRG-11435: primary key value is invalid

NNO-00612: enabling request forwarding

ORA-06441: ssvwatev: Incorrect parameter passed to function call

DRG-10206: failed to perform recovery for a server or client

For more Oracle Errors Interview Questions Click Here