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-01865: not a valid era
ORA-16086: standby database does not contain available standby log files
LRM-00104: 'string' is not a legal integer for 'string'
ORA-26030: index string.string had string partitions made unusable due to:
ORA-29502: NAMED keyword required in CREATE JAVA RESOURCE
TNS-02502: Authentication: unable to find initialization function
PCB-00603: An EXEC TOOLS MESSAGE host variable is not a character type
ORA-24030: Only one of rule or rule-set must be specified
ORA-14166: missing INTO keyword
ORA-16590: no primary established in Data Guard configuration
ORA-24018: STOP_QUEUE on string failed, outstanding transactions found
ORA-00105: too many dispatcher configurations