QSM-02002: DISTINCT aggregate measure in SELECT list



QSM-02002: DISTINCT aggregate measure in SELECT list..

Answer / guest

Cause: The capability in question is not supported when the
materialized view uses the DISTINCT qualifier on an
aggregate function.

Action: Remove the DISTINCT qualifier.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-24336: invalid result set descriptor

1 Answers  


ORA-32020: SID=* clause needed to modify this parameter

1 Answers  


IMG-00842: image index allocation failed

1 Answers  


DRG-11124: invalid value string

1 Answers  


ORA-31433: subscriber view does not exist

1 Answers  






ORA-15059: invalid device type for ASM disk

1 Answers  


ORA-27508: IPC error sending a message

1 Answers  


ORA-14616: table is not subpartitioned by List method

1 Answers  


SQL*Loader-00953: Error shipping read buffer across 2-task

1 Answers  


ORA-13390: error in spatial analysis and mining function: [string]

1 Answers  


ORA-36402: (XSSPROP03) The property '$string' requires a leading "$" because it is a system-reserved property name.

1 Answers  


ORA-28507: error in data dictionary view string

1 Answers  


Categories