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-26535: %ud byte row cache insufficient for table with rowsize=number

ORA-28544: connect to agent failed, probable Net8 administration error

TNS-12164: TNS:Sqlnet.fdf file not present

TNS-12596: TNS:internal inconsistency

ORA-32408: materialized view log on "string"."string" already has new values

ORA-12462: undefined compartment string for policy string

PLS-01417: Use of %%attribute

NNC-00429: invalid octet string literal "string"

TNS-04019: Starting Oracle Connection Manager instance string. Please wait...

ORA-16704: Cannot set the property because it is read-only

ORA-23373: object group "string"."string" does not exist

ORA-16510: messaging error using ksrwait

For more Oracle Errors Interview Questions Click Here