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



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-13377: invalid combination of elements with orientation

1 Answers  


ORA-29325: SET COMPATIBILITY release number lower than string

1 Answers  


DRG-50858: OCI error: string

1 Answers  


ORA-33332: (DSSEXIST01) Use the AW command to establish a current analytic workspace. Then start your current activity again.

1 Answers  


ORA-25454: error during evaluation of rule set: string.string for iterator: string

1 Answers  






ORA-32053: operation not supported

1 Answers  


RMAN-06076: datafile string contains wrong datafile

1 Answers  


ORA-21604: property [string] is not a property of transient or value instances

1 Answers  


RMAN-06161: error when inspecting auxiliary filename: string

1 Answers  


ORA-01414: invalid array length when trying to bind array

1 Answers   Gucci,


TNS-00083: (USER or ADMIN) in the argument field

1 Answers  


ORA-22957: NULL is an invalid input to powermultiset and COLLECT functions

1 Answers  


Categories