HomeOracleOracle Error QSM-02149: ON COMMIT with this MV requires 9.0 compatibility or higher

Oracle Error QSM-02149: ON COMMIT with this MV requires 9.0 compatibility or higher

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.

Share:

Leave a Reply

You May Also Like

Oracle Error Message CLSGN-32767: Internal error. Reason for the Error An unexpected error occurred. Solution Examine the message(s) that accompany...
Oracle Error Message CLSGN-00211: OCR batch operation failed. string Reason for the Error Setting a set of Oracle Cluster Registry...
Oracle Error Message CLSGN-00210: failed to get value for OCR key “string”. string Reason for the Error It was not...