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-23330: column group string already exists

1 Answers  


NNL-00832: Deletes refused, name is a topology name: number

1 Answers  


ORA-01528: EOF while processing SQL statement

1 Answers  


DRG-10100: invalid argument found: string

1 Answers  


NZE-28890: Entrust Login Failed

0 Answers  






ORA-29841: invalid option for ALTER INDEXTYPE

1 Answers  


ORA-18008: cannot find OUTLN schema

1 Answers  


ORA-14310: VALUES LESS THAN or AT clause cannot be used with List partitioned tables

1 Answers  


ORA-01936: cannot specify owner when creating users or roles

1 Answers  


ORA-07593: ssprprv: Error release privileges

1 Answers  


NID-00137: All datafiles that are not dropped should be readable

1 Answers  


ORA-16083: LogMiner session has not been created

1 Answers  


Categories