Oracle Error Message
QSM-02171: the materialized view has a join operation in the outer UNION block
Reason for the Error
Fast refresh is not supported if a materialized view having the UNION operator contains a join operation.
Solution
Rewrite the materialized view query without the join.