QSM-02114: no GROUP BY clause, no aggregates and not >= 9.0
compatibility
- 1 Answers
- 2348 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 |
LSX-00011: internal error: ~s
ORA-31689: illegal value for base worker id, string
TNS-12155: TNS:received bad datatype in NSWMARKER packet
QSM-00767: a SQL cache is not available to user string
DRG-10828: token string is longer than maximum length for column string
ORA-06556: the pipe is empty, cannot fulfill the unpack_message request
ORA-28270: Malformed user nickname for password authenticated global user.
TNS-12224: TNS:no listener
EXP-00016: ORACLE error encountered while reading default auditing options
IMG-00922: location specified without feature
PCC-00041: Unable to open output file "string"
NNF-02003: Unknown NIS error code: string
Oracle Errors 
