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-09318: slkhst: unable to host out to operating system

NNC-00414: invalid name-value binding string "string"

ORA-27126: unable to lock shared memory segment in core

ORA-02020: too many database links in use

CLSS-02001: local node number string, master node number string

ORA-24003: Queue table index string inconsistent with queue table string

ORA-01678: parameter string must be pairs of pattern and replacement strings

AMD-00133: measure #string: analytic workspace measure name not specified

ORA-28664: a partitioned table may not be coalesced as a whole

ORA-06806: TLI Driver: could not complete protocol initialization for SPX

DRG-11730: relation does not exist

LFI-00002: Out of memory. string

For more Oracle Errors Interview Questions Click Here