Oracle Error QSM-01271: query rewrite not possible because a join in materialized view string with table string has eliminated some rows found in query

Oracle Error Message

QSM-01271: query rewrite not possible because a join in materialized view string with table string has eliminated some rows found in query

Reason for the Error

A join from the materialized view to any table that eliminates some rows should be be present in the query. Otherwise query rewrite will not occur.

Solution

None