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


QSM-02117: missing GROUPING_ID or GROUPING functions on
GROUP BY column(s)



QSM-02117: missing GROUPING_ID or GROUPING functions on GROUP BY column(s)..

Answer / guest

Cause: The capability in question is not supported when the
materialized view uses grouping sets but omits the relevant
GROUPING_ID or GROUPING functions.

Action: Re-phrase the query to include the relevant
GROUPING_ID or GROUPING functions.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-28557: unknown string for database link to non-Oracle system

1 Answers  


ORA-10641: Cannot find a rollback segment to bind to

1 Answers  


RMAN-08011: including current controlfile in backupset

1 Answers  


ORA-21601: attribute is not an object

1 Answers  


NNL-00298: No cache dump currently scheduled

1 Answers  






ORA-09916: Required password was not specified.

1 Answers  


ORA-01417: a table may be outer joined to at most one other table

1 Answers  


NNL-00807: Queries received, type SOA: number

1 Answers  


SQL*Loader-00470: table string does not have system generated OID

1 Answers  


EXP-00021: can only perform incremental export in Full Database mode

1 Answers  


IMP-00033: Warning: Table "string" not found in export file

2 Answers  


ORA-31045: Cannot store more than string extras outside the root XML node

1 Answers  






Categories