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-31418: source schema string does not exist

1 Answers  


DRG-11623: URL store: unknown error getting string

1 Answers  


ORA-16125: large transaction string string string is waiting for more data

1 Answers  


RMAN-10014: PL/SQL error number on line number column number: string

1 Answers  


NNL-00350: No save config currently scheduled

1 Answers  






TNS-12529: TNS:connect request rejected based on current filtering rules

1 Answers  


NNL-00300: Cancelled server cache dump

1 Answers  


ORA-32581: missing or invalid password

1 Answers  


ORA-16596: object not part of the Data Guard broker configuration

1 Answers  


ORA-01494: invalid SIZE specified

1 Answers  


IMP-00017: following statement failed with ORACLE error number:

1 Answers  


ORA-00299: must use file-level media recovery on data file string

1 Answers  


Categories