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-06816: TLI Driver: could not set the SPX SAP address

1 Answers  


DRG-12435: highlight table allocation failed

1 Answers  


ORA-35062: (QFGET01) Duplicate files found for extension number number of EIF file string.

1 Answers  


QSM-02127: not supported for this type mv by Oracle version at master site

1 Answers  


QSM-00771: the specified SQL statement cannot be stored in the workload because it has no valid table references

1 Answers  


DRG-10817: CONTAINS term consists of stopword or phrase of stopwords: string

1 Answers  


LSX-00110: facet "~S" should have single value attribute

1 Answers  


ORA-31104: Cannot find lock with token "string" on "string" for unlock

1 Answers  


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

1 Answers  


PCC-02314: cannot evaluate constant sizeof expression

1 Answers  


NID-00141: No database name specified, previous attempt used string

1 Answers  


RMAN-06250: Report of files that need backup due to unrecoverable operations

1 Answers  


Categories