Oracle Error QSM-01049: semi-join check failed for materialized view, string

Oracle Error Message

QSM-01049: semi-join check failed for materialized view, string

Reason for the Error

If there is a semi join in the query, then Query Rewrite will create (select distinct , from mjv) where is the list of rowids/pk of all mjv tables that don’t correspond to a right side of a semi-join and are their columns. Query Rewrite will not occur if a join from the materialized view cannot match the semi-join from the query.

Solution

None