Oracle Error QSM-01042: anchor and matching join arc check failed for string

Oracle Error Message

QSM-01042: anchor and matching join arc check failed for string

Reason for the Error

If there is a lossy join in the materialized view that doesn’t exist in the query, query rewrite will not take place.

Solution

None