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

NZE-28853: Initialization failure

1 Answers  


ORA-06605: LU6.2 Driver: Unexpected line turnaround

1 Answers  


DRG-11809: Partial Content

1 Answers  


ORA-13272: geometric object string in table string is invalid

1 Answers  


NNL-01064: Statistic counter reset interval: string

1 Answers  






ORA-24508: Buffer is not aligned correctly.

1 Answers  


ORA-06565: cannot execute string from within stored procedure

1 Answers  


ORA-25243: CONSUMER_NAME cannot be specified when dequeuing from exception queue string.string

1 Answers  


ORA-30013: undo tablespace 'string' is currently in use

1 Answers  


TNS-00514: Contexts have different wait/test functions

1 Answers  


ORA-12654: Authentication conversion failed

1 Answers  


ORA-37079: (XSMCSESS07) Aggmap workspace object cannot be used for AGGREGATE.

1 Answers  


Categories