QSM-01095: no suitable grouping_id found in MV with grouping
sets



QSM-01095: no suitable grouping_id found in MV with grouping sets..

Answer / guest

Cause: If materialized aggregate view contains grouping
sets, then it also must contain the grouping_id() function.
This function must contain all columns in the MV GROUP BY.

Action: none

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-32315: REFRESH FAST of "string"."string" unsupported after mixed DML and Direct Load

1 Answers  


ORA-26667: invalid STREAMS parameter string

1 Answers  


ORA-01205: not a data file - type number in header is string

1 Answers  


TNS-01090: No longer listening on: string

1 Answers  


ORA-26715: time limit reached

1 Answers  






PLS-00582: attribute declarations are not allowed in opaque types

1 Answers  


ORA-02143: invalid STORAGE option

1 Answers  


SQL*Loader-00510: Physical record in data file (string) is longer than the maximum(number)

1 Answers  


NNC-00052: client and server protocol versions are incompatible

1 Answers  


ORA-26690: datatype not supported at non-Oracle system

1 Answers  


ORA-00991: only MAC privileges may be granted to procedures

1 Answers  


ORA-01782: UNRECOVERABLE cannot be specified for a cluster or clustered table

1 Answers  


Categories