Database Error Messages

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

QSM-02086

Materialized view uses the MIN, MAX, ANY_VALUE, BIT_*_AGG, BOOLEAN_*_AGG, or EVERY aggregate function.

Cause

Fast refresh after an update or delete was not supported because the materialized view used the MIN, MAX, ANY_VALUE, BIT_*_AGG, BOOLEAN_*_AGG, or EVERY aggregate function.


Action

Rephrase the query to avoid using MIN, MAX, ANY_VALUE, BIT_*_AGG, BOOLEAN_*_AGG, or EVERY aggregate function.