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


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

ORA-01606: gc_files_to_locks not identical to that of another mounted instance

1 Answers  


RMAN-06590: tablespace string cannot be converted

1 Answers  


TNS-01108: Listener password prompt failed

1 Answers  


ORA-26033: Direct path operation not supported on table with encrypted colum

1 Answers  


ORA-00911: invalid character

1 Answers  






ORA-29288: invalid file name

1 Answers  


ORA-32624: illegal reordering of MODEL dimensions

1 Answers  


ORA-27086: unable to lock file - already in use

1 Answers  


ORA-02300: invalid value for OIDGENERATORS

1 Answers  


ORA-00319: log string of thread string has incorrect log reset status

1 Answers  


ORA-10920: Cannot offline tablespace belonging to default temporary tablespace group

1 Answers  


SQL*Loader-00125: specified value for readsize(number) less than max_record_size(number)

1 Answers  






Categories