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