Oracle Error QSM-02199: PCT FAST REFRESH is not possible if WHERE clause includes a subquery

Oracle Error Message

QSM-02199: PCT FAST REFRESH is not possible if WHERE clause includes a subquery

Reason for the Error

The capability in question was not supported because the materialized view query WHERE clause included a subquery.

Solution

Rephrase the query to avoid the use of a subquery in the WHERE clause.