Oracle Error QSM-02044: ORDER BY clause in mv

Oracle Error Message

QSM-02044: ORDER BY clause in mv

Reason for the Error

The capability in question is not supported when the materialized view includes an ORDER BY clause.

Solution

Remove the ORDER BY clause.