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
- 3068 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-33270: (DBERR05) Analytic workspace string already exists.
NNL-00993: Auto-refresh failure retry expiration: string
ORA-12983: cannot drop all columns in a table
ORA-38402: invalid name: empty string or spaces in the name
ORA-22984: view query cannot contain references to a super view
ORA-28107: policy was disabled
RMAN-06053: unable to perform media recovery because of missing log
SQL*Loader-00652: Invalid zoned decimal byte.
EXP-00015: error on row number of table string, column string, datatype number
ORA-29760: instance_number parameter not specified
ORA-08340: This command not allowed on nCUBE, only one thread is ever used.
ORA-16102: remote information is not available on the specified primary
Oracle Errors 
