Oracle Error Message
QSM-01085: materialized view, string, has a lossy join between tables, string
Reason for the Error
There are no primary key, foreign key constraints between these tables. But query rewrite is still possible if the lossy join between the above tables also appear in the query
Solution
None