Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

QSM-02198

PCT FAST REFRESH is not possible if HAVING clause includes a subquery

Cause

The capability in question was not supported because the materialized view query HAVING clause included a subquery.


Action

Rephrase the query to avoid the use of a subquery in the HAVING clause.