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-32502: Cannot execute command. Flash Freeze is not in effect

1 Answers  


TNS-01033: Listener Parameter File string

1 Answers  


UDI-00014: invalid value for parameter, 'string'

1 Answers  


ORA-06743: TLI Driver: cannot alloc t_bind

1 Answers  


ORA-39116: invalid trigger operation on mutating table string.string

1 Answers  


ORA-29335: tablespace 'string' is not read only

1 Answers  


ORA-13224: zero tolerance specified for layer in USER_SDO_GEOM_METADATA

1 Answers  


DRG-11821: Payment Required

1 Answers  


ORA-23381: generated object for base object string.string@string does not exist

1 Answers  


UDI-00003: all allowable logon attempts failed

1 Answers  


ORA-09846: soacon: ARCH unable to open named pipe.

1 Answers  


TNS-02512: Invalid status received

1 Answers  


Categories