Oracle Error QSM-01110: query rewrite not possible with materialized view string because it contains a join between tables (string) that is not present in the query and that potentially eliminates rows needed by the query

Oracle Error Message

QSM-01110: query rewrite not possible with materialized view string because it contains a join between tables (string) that is not present in the query and that potentially eliminates rows needed by the query

Reason for the Error

All lossy joins in the materialized view must be present in the query for query rewrite to occur.

Solution

None