QSM-02062: GROUP BY clause in mv



QSM-02062: GROUP BY clause in mv..

Answer / guest

Cause: The capability in question is not supported when the
materialized view uses the GROUP BY clause.

Action: Re-phrase the query to avoid the use of the GROUP BY
clause.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NCR-01004: NCRS: Write error.

1 Answers  


ORA-12007: materialized view reuse parameters are inconsistent

1 Answers  


RMAN-00565: unable to read input file

1 Answers  


ORA-40102: invalid input string for data mining operation string

1 Answers  


SQL*Loader-00265: Unable to get default character set name.

1 Answers  






PLS-00216: NUMBER precision constraint must be in range (1 .. 38)

1 Answers  


UDE-00015: invalid context or job state for parameter, 'string'.

1 Answers  


ORA-28561: unable to set date format on non-Oracle system

1 Answers  


PLS-00587: a static method cannot be invoked on an instance value

1 Answers  


QSM-02171: the materialized view has a join operation in the outer UNION block

1 Answers  


DGM-16906: Unable to accept commands: no memory

1 Answers  


ORA-01511: error in renaming log/data files

1 Answers  


Categories