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

SQL-02155: Date Time Interval only valid with Dynamic=ANSI

RMAN-06223: starting up automatic instance string

ORA-27029: skgfrtrv: sbtrestore returned error

ORA-32008: error while processing parameter update at instance string

NNL-00980: Forwarding failures: number

ORA-00130: invalid listener address 'string'

NNF-02005: NIS key string does not exist in map string

ORA-19902: incarnation key string not found

ORA-16606: unable to find property "string"

ORA-02831: Segment deallocation failed - empty segment list

ORA-32846: Messaging Gateway agent cannot be started; status is string

PLS-00373: EXIT label 'string' must label a LOOP statement

For more Oracle Errors Interview Questions Click Here