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-06032: NETDNT: connect failed, access control data rejected

1 Answers  


DRG-10599: column is not indexed

1 Answers  


ORA-15069: ASM file 'string' not accessible; timed out waiting for lock

1 Answers  


PLS-01910: : associative array shape is not consistent with session parameters

1 Answers  


ORA-19757: could not resize change tracking file to string blocks

1 Answers  


SQL*Loader-00609: value used for ROWS parameter changed from number to number

1 Answers  


ORA-09967: scumnt: unable to create or open file

1 Answers  


DRG-11612: URL store: unknown host specified in string

1 Answers  


DRG-10831: can not insert into feedback table string

1 Answers  


LSX-00330: missing range start character

1 Answers  


ORA-33223: (CMOVE03) You cannot move a session-only dimension value.

1 Answers  


ORA-01188: Block size string in header does not match physical block size string

1 Answers  


Categories