Oracle Error QSM-02011: a HAVING clause is present

Oracle Error Message

QSM-02011: a HAVING clause is present

Reason for the Error

The capability in question is not supported when the materialized view uses a HAVING clause.

Solution

Remove the HAVING clause.