Oracle Error Message
QSM-02106: mv uses a filter condition in the WHERE or HAVING clause
Reason for the Error
The capability in question is not supported when the materialized view includes a filter condition in the WHERE or HAVING clause.
Solution
Re-phrase the query to avoid the use of filter conditions in the WHERE or HAVING clauses.
