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 |
AUD-00706: unsupported or corrupted input format
ORA-14168: only one subpartition may be modified
ORA-07842: sllfcl: SYS$CLOSE failure
TNS-01163: Failed to spawn process: string
ORA-38744: file string is not the same file seen at start of flashback
ORA-16537: child count exceeded
LPX-00317: undefined decimal-format "~S"
ORA-19555: invalid LOG_ARCHIVE_MIN_SUCCEED_DEST parameter value
ORA-12350: database link being dropped is still mounted
ORA-12803: parallel query server lost contact with another server
DRG-12516: language column must be specified when using the multi stoplist
ORA-36961: Oracle OLAP is not available.