Oracle Error Message
QSM-01602: equivalence, string, requires join back to table, string, on column, string
Reason for the Error
A column in the query does not appear in the equivalence. Query rewrite will try to obtain this column from the base table, by doing a join back to that column with a materialized view. But join backs are not allowed for equivalence rewrite as the required constraints are not guaranteed to be found on the tables in the destination statement of the equivalence.
Solution
None