Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-07223: slspool: fork error, unable to spawn spool process.

1 Answers  


ORA-22955: The cardinality parameter is not within the allowed limits

1 Answers  


LCD-00215: parameter files nested too deep [string]

1 Answers  


ORA-27081: unable to close the file

1 Answers  


ORA-29819: cannot associate default values with columns

1 Answers  






ORA-09939: Restoration of signal handlers failed.

1 Answers  


ORA-13787: missing SQL profile for statement object "string" for tuning task "string"

1 Answers  


NNF-03003: Format error parsing server response

1 Answers  


TNS-04144: Nothing to migrate

1 Answers  


ORA-12228: TNS:protocol adapter not loadable

1 Answers  


ORA-13294: cannot transform geometry containing circular arcs

1 Answers  


QSM-02086: mv uses the MIN or MAX aggregate functions

1 Answers  






Categories