Oracle Error QSM-02008: non-join filter condition in WHERE or HAVING clause

Oracle Error Message

QSM-02008: non-join filter condition in WHERE or HAVING clause

Reason for the Error

The capability in question is not supported when the materialized view has a selection condition (an expression not representing a join) in the WHERE or HAVING clauses.

Solution

Remove the selection filter expression.