Oracle Error QSM-02202: PCT FAST REFRESH is not possible if query has ORDER BY clause

Oracle Error Message

QSM-02202: PCT FAST REFRESH is not possible if query has ORDER BY clause

Reason for the Error

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

Solution

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