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

NNL-00017: cannot start server, program "string" does not exist

1 Answers  


ORA-01510: error in deleting log files

1 Answers  


ORA-01987: client os username is too long

1 Answers  


ORA-02776: Value for request done signal exceeds maximum

1 Answers  


SQL*Loader-00935: Error verifying required option for parallel load.

1 Answers  






RMAN-08009: channel string: starting archive log backupset

1 Answers  


ORA-30015: previously offlined undo tablespace 'string' is still pending

1 Answers  


ORA-23367: table string is missing the primary key

1 Answers  


ORA-02050: transaction string rolled back, some remote DBs may be in-doubt

1 Answers  


ORA-01234: cannot end backup of file string - file is in use or recovery

1 Answers  


DRG-11810: Partial Update OK

1 Answers  


ORA-12476: least upper bound resulted in an invalid OS label

1 Answers  


Categories