Oracle Error Message
QSM-02021: set operator encountered in mv
Reason for the Error
The capability in question is not supported when the materialized view uses set operators such as UNION, UNION ALL, MINUS, etc.
Solution
Re-phrase the query to avoid the use of set operators.