Database Error Messages

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

QSM-02202

PCT FAST REFRESH is not possible if query has ORDER BY clause

Cause

The capability in question was not supported because the materialized view query contained an ORDER BY clause.


Action

Rephrase the query to avoid the use of the ORDER BY clause.