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 |
TNS-03602: Insufficient arguments. Usage: trcroute <address>
ORA-01113: file string needs media recovery
ORA-34481: (MXMAINT07) You cannot string values of PARTITION TEMPLATE workspace object.
NPL-00304: uninitialized ASN.1 tag attribute
ORA-33332: (DSSEXIST01) Use the AW command to establish a current analytic workspace. Then start your current activity again.
ORA-32032: free temporary object number not available
PLS-00391: undefined column 'string' in UPDATE statement
NZE-28844: No wallet present
ORA-25280: complete sender information not provided to non-repudiate sender
ORA-08447: syntax error in USAGE clause in mask options
ORA-16108: database is no longer a standby database
ORA-30151: File already exists