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
- 2915 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-00238: invalid Nmtoken "~S"
ORA-14013: duplicate partition name
NNL-00970: System query index number: number
ORA-31657: data filter name can not be defaulted
ORA-30033: Undo tablespace cannot be specified as default user tablespace
NNF-00110: no values exist
TNS-04207: Trace Assistant Internal ERROR: Packet Length
SQL-02135: Unable to initialize date format using supplied mask
ORA-24506: invalid attempt to change character set id on env handle
PCC-00024: Indicator variable "string" has wrong type or length at line number in file string
ORA-06005: NETASY: dialogue file read failure
ORA-30449: syntax error in parameter string
Oracle Errors 
