Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-24812: character set conversion to or from UCS2 failed

1 Answers  


ORA-39056: invalid log file specification.

1 Answers  


NNF-04000: File succesfully converted

1 Answers  


RMAN-06170: no controlfile copy found with offline range recid string stamp string datafile string

1 Answers  


ORA-01178: file string created before last CREATE CONTROLFILE, cannot recreate

1 Answers  






RMAN-06421: sent command to channel: string

1 Answers  


ORA-22628: OCIAnyData already constructed

1 Answers  


PCB-00235: Table size mismatch in INTO/USING. Minimum is: number

1 Answers  


IMP-00062: Warning: The identifier on the dump file for object type "string"."string" is invalid

1 Answers  


LFI-00139: Option string cannot be used with option string in calling string.

1 Answers  


ORA-16764: log tranport service for some standby database unexpectedly offline

1 Answers  


ORA-10584: Can not invoke parallel recovery for test recovery

1 Answers  






Categories