Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

QSM-02114: no GROUP BY clause, no aggregates and not >= 9.0

QSM-02114: no GROUP BY clause, no aggregates and not >= 9.0 compatibility..

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

Post New Answer

More Oracle Errors Interview Questions

ORA-39000: bad dump file specification

1 Answers   Oracle,

KUP-04000: error initializing IO state for file string in string

1 Answers  

ORA-31434: purge is currently running

1 Answers  

ORA-01303: subordinate process error: number. Check alert and trace logs

1 Answers  

ORA-00279: change string generated at string needed for thread string

1 Answers  

ORA-01613: instance string (thread string) only has string logs - at least 2 logs required to enable.

1 Answers  

TNS-01057: Program name: string

1 Answers  

In my project I am using star schema and only diimension tables are loaded and not fact tables any one can help me why it is happening? Plase guide me.

0 Answers  

ORA-01240: too many data files to add in one command

1 Answers  

DRG-11111: value of string must be between string and string

1 Answers  

ORA-09959: IMON: deletion of a process failed.

1 Answers  

ORA-30567: name already used by an existing log group

1 Answers