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

PCC-02405: Variable is of undefined type

1 Answers  


LPX-00244: invalid use of less-than ('<') character (use <)

1 Answers  


ORA-24014: invalid value string, RETENTION_TIME should be FOREVER or non-negative

1 Answers  


ORA-24002: QUEUE_TABLE string does not exist

1 Answers  


RMAN-06706: could not close file: "string" (reason=string)

1 Answers  






ORA-02347: cannot grant privileges on columns of an object table

1 Answers  


ORA-08106: cannot create journal table string.string

1 Answers  


ORA-37084: Output valueset string must match string's dimesnionality

1 Answers  


ORA-40211: algorithm name string is invalid

1 Answers  


LRM-00113: error when processing file 'string'

1 Answers  


ORA-32331: type "string"."string" is incompatible with the master site

1 Answers  


ORA-28558: HS_FDS_CONNECT_STRING undefined for non-Oracle system

1 Answers  


Categories