Oracle Error QSM-02200: PCT FAST REFRESH is not possible if query contains LEFT OUTER, RIGHT OUTER or FULL OUTER JOIN

Oracle Error Message

QSM-02200: PCT FAST REFRESH is not possible if query contains LEFT OUTER, RIGHT OUTER or FULL OUTER JOIN

Reason for the Error

The capability in question was not supported because the materialized view query contained LEFT OUTER, RIGHT OUTER or FULL OUTER JOIN.

Solution

Rephrase the query to avoid the use of LEFT OUTER, RIGHT OUTER or FULL OUTER JOIN.