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-12900: Operation:string for index: string has already been started

1 Answers  


ORA-16612: string value too long for attribute "string"

1 Answers  


ORA-14403: cursor invalidation detected after getting DML partition lock

1 Answers  


LFI-00106: Path object holds more than one path.

1 Answers  


TNS-01409: Instance "string"

1 Answers  






ORA-06549: PL/SQL: failed to dynamically open shared object (DLL): string

2 Answers  


QSM-00761: the priority string is invalid for the current operation

1 Answers  


DRG-11711: too much data for term string

1 Answers  


ORA-16138: end of log stream not received from primary

1 Answers  


PLS-00571: method access through data base link not yet supported on client side

1 Answers  


TNS-00207: Uptime : number days number hr. number min. number sec

1 Answers  


PCB-00311: Datatype equivalencing is an Oracle extension

1 Answers  


Categories