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-36652: (XSDUNION11) workspace object is not a string type dimension.
ORA-01685: max # extents (string) reached in index string.string partition string
SQL*Loader-00962: Error setting user-side Ctrl-C handler
ORA-01229: data file string is inconsistent with logs
ORA-34344: (MXDSS03) Analytic workspace string is not attached.
ORA-25148: ONLINE option not permitted
LPX-00402: invalid axisname in the XSL file
DRG-51017: unable to open storage buffer for fuzzy match candidates
ORA-16717: clearing parameter LOG_ARCHIVE_DUPLEX_DEST failed
ORA-39058: current object skipped: string of type string
RMAN-10000: error parsing target database connect string "string"
ORA-31675: worker process interrupt for unexpected death of master process