Oracle Error Message
QSM-02034: no joins are present in the HAVING clause
Reason for the Error
The capability in question is not supported when the materialized view includes no joins in the HAVING clause.
Solution
Re-phrase the query to include a join.