QSM-01096: Materialized view with grouping sets contains
duplicates



QSM-01096: Materialized view with grouping sets contains duplicates..

Answer / guest

Cause: Materialized view with grouping sets contains
duplicates and no rewrite is supported for it. For example,
GROUP BY GROUPING SET ((a), (a)) is not supported for rewrite.

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

LSX-00265: attribute "~1S" value "~2S" is wrong (must be "~3S")

1 Answers  


ORA-24058: cannot downgrade QUEUE_TABLE that has propagation in a prepared state

1 Answers  


ORA-38459: XML Tag "string" not found for the XMLType attribute "string"

1 Answers  


QSM-02176: MV with UNION ALL in a view is too complex

1 Answers  


ORA-12481: effective label not within program unit clearance range

1 Answers  






ORA-16123: transaction string string string is waiting for commit approval

1 Answers  


PCC-00024: Indicator variable "string" has wrong type or length at line number in file string

1 Answers  


PLS-00658: constructor method name must match type name

1 Answers  


ORA-09845: soacon: Archmon unable to open named pipe.

1 Answers  


ORA-02047: cannot join the distributed transaction in progress

1 Answers  


NNL-00987: Authoritative answers when authority: number

1 Answers  


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

1 Answers  


Categories