QSM-02004: grouping column omitted from SELECT list



QSM-02004: grouping column omitted from SELECT list..

Answer / guest

Cause: The capability in question is not supported when the
materialized view contains a column or expression in the
GROUP BY clause that is not also present in the list of
output select expressions.

Action: Include all GROUP BY expressions in the output
select list.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

DRG-11833: Request-URI Too Big

1 Answers  


ORA-29541: class string.string could not be resolved

1 Answers  


ORA-09842: soacon: Archmon unable to create named pipe.

1 Answers  


ORA-13129: HHCODE column string not found

1 Answers  


ORA-25216: invalid recipient, either NAME or ADDRESS must be specified

1 Answers  






ORA-01883: overlap was disabled during a region transition

1 Answers  


ORA-30352: inconsistent numeric precision or string length

1 Answers  


IMG-00842: image index allocation failed

1 Answers  


ORA-30688: maximum program calling depth exceeded

1 Answers  


PLS-01500: Unions are not allowed in the definition of a view

1 Answers  


PLS-00601: partition extended object names may only be used with tables

1 Answers  


ORA-13011: value is out of range

1 Answers  


Categories