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-38413: elementary attribute name may not be longer than 32 characters
TNS-12623: TNS:operation is illegal in this state
ORA-09748: pws_look_up: fork failed
RMAN-06451: proxy copy handle=string recid=string stamp=string
ORA-36266: (XSCGMDLAGG00) Invalid context for the AGGREGATION function
TNS-01171: Event detection broke for dispatcher: string
QSM-02128: does not meet the requirements of a primary key mv
ORA-16617: unknown object identifier specified in request
ORA-24090: at least one protocol must be enabled
DRG-52206: error while registering index object
O2F-00321: Error opening the OUTTYPE file for writing
ORA-16756: Resource guard could not open standby readonly