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 |
DRG-10520: failed to drop index: string
ORA-07432: unable to perform nested sleep
ORA-02714: osnpwr: message send failure
ORA-23316: the masterdef is string
LCD-00211: unexpected delimiter [string]
KUP-04040: file string in string not found
PCB-00219: Invalid size specified in EXEC SQL VAR statement
ORA-02452: invalid HASHKEYS option value
ORA-26718: transaction limit reached
PCC-00009: Invalid host variable at column number in line number of file string
PCC-00025: Undeclared indicator variable "string" at line number in file string
TNS-00534: Failed to grant connection ownership to child