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 |
PCB-00403: EXEC statement cannot begin in Area A
ORA-06604: LU6.2 Driver: Unable to allocate session with remote LU
NZE-29015: incorrect message length
ORA-12198: TNS:could not find path to destination
ORA-12486: effective max labels and min labels cannot be changed
ORA-24386: statement/server handle is in use when being freed
RMAN-06604: new RMAN configuration parameters are successfully stored
TNS-00013: INTCTL: error while performing NS disconnect command
PLS-01403: Comment delimiters /* */
ORA-30447: internal data for run number string is inconsistent
ORA-00123: idle public server terminating
RMAN-08580: channel string: starting datafile copy