Database Error Messages

QSM-02220

File Change Tracking (FCT) FAST REFRESH is not possible if HAVING clause includes a subquery.

Cause

This capability is not supported because the materialized view query HAVING clause includes a subquery.


Action

Avoid using a subquery in the HAVING clause.