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-36652: (XSDUNION11) workspace object is not a string type dimension.

1 Answers  


ORA-01685: max # extents (string) reached in index string.string partition string

1 Answers  


SQL*Loader-00962: Error setting user-side Ctrl-C handler

1 Answers  


ORA-01229: data file string is inconsistent with logs

1 Answers  


ORA-34344: (MXDSS03) Analytic workspace string is not attached.

1 Answers  






ORA-25148: ONLINE option not permitted

1 Answers  


LPX-00402: invalid axisname in the XSL file

1 Answers  


DRG-51017: unable to open storage buffer for fuzzy match candidates

1 Answers  


ORA-16717: clearing parameter LOG_ARCHIVE_DUPLEX_DEST failed

1 Answers  


ORA-39058: current object skipped: string of type string

1 Answers  


RMAN-10000: error parsing target database connect string "string"

1 Answers  


ORA-31675: worker process interrupt for unexpected death of master process

1 Answers  


Categories