Oracle Error Message
QSM-02149: ON COMMIT with this MV requires 9.0 compatibility or higher
Reason for the Error
You have specified a materialized view that uses some combination of the following: joins aggregation filter conditions in the WHERE clause a remote relation in the FROM list a SUM(x) function without a corresponding COUNT(x) function an omitted COUNT(*) aggregate function a MIN() or MAX() aggregate function in combination with the REFRESH ON COMMIT option while running in less than 9.0 compatibility mode.
Solution
Set your compatibility mode to 9.0 or higher or restructure the materialized view query.