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-01478: array bind may not include any LONG columns

1 Answers  


RMAN-05009: Block Media Recovery requires Enterprise Edition

1 Answers  


LSX-00291: value "~1S" is less than minimum "~2S" (~3S)

1 Answers  


ORA-29845: indextype does not support local domain index on string partitioned table

1 Answers  


PLS-00500: invalid operator binding

1 Answers  






IMG-00520: invalid value for numberOfBands

1 Answers  


ORA-14622: Value string already exists in subpartition string

1 Answers  


DRG-11503: insert statement overflows maximum statement size

1 Answers  


ORA-12854: Parallel query is not supported on temporary LOBs

1 Answers  


TNS-12537: TNS:connection closed

1 Answers   IBM,


ORA-25127: RELY not allowed in NOT NULL constraint

1 Answers  


NCR-01019: NCRS: Checksumming failure.

1 Answers  


Categories