Oracle Error QSM-02030: reduced precision specified for prebuilt mv

Oracle Error Message

QSM-02030: reduced precision specified for prebuilt mv

Reason for the Error

The capability in question is not supported when the materialized view is created with the WITH REDUCED PRECISION clause.

Solution

DROP the materialized view and re-create it without using the WITH REDUCED PRECISION clause.