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
- 2989 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 |
DRG-13010: alt_value is already used by another sub lexer
ORA-07432: unable to perform nested sleep
RMAN-06051: DELETE INPUT option not implemented yet
ORA-03289: partition name and segment type do not match
DRG-51019: unable to open or illegal format for fuzzy match data file: string
ORA-26028: index string.string initially in unusable state
TNS-00232: Unable to setup connection
ORA-01636: rollback segment 'string' is already online
ORA-06141: NETTCP: no privilege for user
ORA-12166: TNS:Client can not connect to HO agent.
RMAN-06095: a backup controlfile must be restored to recover datafile string
ORA-24354: number fetched too large to fit in COBOL display type buffer.
Oracle Errors 
