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

TNS-00312: Connection Manager: Failed to get version information

1 Answers  


ORA-00710: new tablespace name is the same as the old tablespace name

1 Answers  


ORA-07215: slsget: getrusage error.

1 Answers  


ORA-32845: Messaging Gateway agent is already running

1 Answers  


ORA-13283: failure to get new geometry object for conversion in place

1 Answers  






ORA-06124: NETTCP: timeout waiting for ORASRV

1 Answers  


SQL*Loader-00650: incomplete lob data written for column string, row number, table string

1 Answers  


ORA-31090: invalid database schema name "string"

1 Answers  


ORA-14016: underlying table of a LOCAL partitioned index must be partitioned

1 Answers  


ORA-27510: IPC error waiting for a request to complete

1 Answers  


CLSR-06507: Cannot add to SERVICE_NAMES, SERVICE_NAMES will be too long

1 Answers  


UDE-00010: multiple job modes requested, string and string.

1 Answers  


Categories