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

RMAN-02007: Integer value overflow

SQL*Loader-00507: unexpected EOF reading SDF or LOBFILE string for column string in table string

LFI-01521: fsync() failed(OSD return value = string) in string.

ORA-12092: cannot online redefine replicated table "string"."string"

NZE-29015: incorrect message length

ORA-13450: GeoRaster metadata layerInfo error

RMAN-00555: target database connect string must be specified

ORA-14513: partitioning column may not be of object datatype

ORA-23456: flavor string does not contain "string"

ORA-16501: the Data Guard broker operation failed

NZE-28767: invalid version number

ORA-06142: NETTCP: error getting user information

For more Oracle Errors Interview Questions Click Here