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

NNL-00957: Name nodes created: number

1 Answers  


EXP-00048: Cannot export SYSAUX Tablespace for Point-in-time Recovery or Transportable Tablespace

1 Answers  


TNS-12600: TNS: string open failed

1 Answers  


ORA-02149: Specified partition does not exist

1 Answers  


NNL-00853: Renames refused, new name already exists: number

1 Answers  






ORA-27418: syntax error in repeat interval

1 Answers  


ORA-30381: REWRITE_TABLE is not compatible with Oracle version

1 Answers  


ORA-31039: XML namespace length string exceeds maximum string

1 Answers  


ORA-13150: failed to insert exception record

1 Answers  


PCC-02205: Parser error at line number, column number, file string:

1 Answers  


ORA-24377: invalid OCI function code

1 Answers  


ORA-09266: spawn: error starting an Oracle process

1 Answers  






Categories