Interested to Buy Any Domain ? << Click Here >> for more details...
QSM-02114: no GROUP BY clause, no aggregates and not >= 9.0
compatibility
- 1 Answers
- 2928 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: The capability in question is not supported when the
materialized view has no GROUP BY clause, no aggregates and
compatibility mode is less than 9.0.
Action: Re-phrase the query to avoid the include a GROUP BY
clause or an aggregate function. Or set compatibility mode
to 9.0 or greater.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-01682: read-only DB cannot allocate temporary space in tablespace string
ORA-13042: invalid SDO_LEVEL and SDO_NUMTILES combination
ORA-28020: IDENTIFIED GLOBALLY already specified
TNS-12231: TNS:No connection possible to destination
QSM-01027: materialized view, string, is unusable
ORA-02191: correct syntax is: SET TRANSACTION USE ROLLBACK SEGMENT <rbs>
DRG-50928: reserved failure on line string on column string
ORA-30375: materialized view cannot be considered fresh
ORA-14646: Specified alter table operation involving compression cannot be performed in the presence of usable bitmap indexes
TNS-00225: Unable to bequeath connection to pump
ORA-13037: SRIDs do not match for the two geometries
ORA-10640: Operation not permitted during SYSTEM tablespace migration
Oracle Errors 
