Oracle Error Message
QSM-02058: set operator in mv and compatibility mode is less than 9.0
Reason for the Error
The capability in question is not supported when the materialized view uses a set operator and the compatibility mode is less than 9.0.
Solution
Re-phrase the query to avoid the use of set operators or set the compatibility mode to 9.0 or greater.