Oracle Error Message
QSM-01084: materialized view string has an anchor table string not found in query
Reason for the Error
A table in a materialized view is an anchor, (a) if it is not joined to any other table or (b) joined to other tables but each of its joins is either lossy or lossless with the above table being child-side table. If an anchor which is present in the materialized view is not found in the query, then query rewrite will not take place.
Solution
None
