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

ORA-29388: plan/consumer_group string is part of more than one top-plan

1 Answers  


NNO-00304: listen address string length string exceeds maximum of string

1 Answers  


ORA-26053: Row was not loaded due to conversion error.

1 Answers  


ORA-22860: object type expected

1 Answers  


ORA-27477: "string.string" already exists

1 Answers  






TNS-12582: TNS:invalid operation

1 Answers  


ORA-07447: ssarena: usinit failed.

1 Answers  


RMAN-06497: WARNING: controlfile is not current, controlfile autobackup skipped

1 Answers  


ORA-13798: Parameter string cannot be NULL.

1 Answers  


ORA-29393: user string does not exist or is not logged on

1 Answers  


QSM-01070: equivalence class manager was not found

1 Answers  


NNO-00252: invalid administrative region parameter string value "string"

1 Answers  


Categories