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 |
ORA-29388: plan/consumer_group string is part of more than one top-plan
NNO-00304: listen address string length string exceeds maximum of string
ORA-26053: Row was not loaded due to conversion error.
ORA-22860: object type expected
ORA-27477: "string.string" already exists
TNS-12582: TNS:invalid operation
ORA-07447: ssarena: usinit failed.
RMAN-06497: WARNING: controlfile is not current, controlfile autobackup skipped
ORA-13798: Parameter string cannot be NULL.
ORA-29393: user string does not exist or is not logged on
QSM-01070: equivalence class manager was not found
NNO-00252: invalid administrative region parameter string value "string"