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



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

Answer / guest

Cause: 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.

Action: Set your compatibility mode to 9.0 or higher or
restructure the materialized view query.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

TNS-03602: Insufficient arguments. Usage: trcroute <address>

1 Answers  


ORA-01113: file string needs media recovery

1 Answers  


ORA-34481: (MXMAINT07) You cannot string values of PARTITION TEMPLATE workspace object.

1 Answers  


NPL-00304: uninitialized ASN.1 tag attribute

1 Answers  


ORA-33332: (DSSEXIST01) Use the AW command to establish a current analytic workspace. Then start your current activity again.

1 Answers  






ORA-32032: free temporary object number not available

1 Answers  


PLS-00391: undefined column 'string' in UPDATE statement

1 Answers  


NZE-28844: No wallet present

1 Answers  


ORA-25280: complete sender information not provided to non-repudiate sender

1 Answers  


ORA-08447: syntax error in USAGE clause in mask options

1 Answers  


ORA-16108: database is no longer a standby database

1 Answers  


ORA-30151: File already exists

1 Answers  


Categories