QSM-02084: DISTINCT clause on a duplicate sensitive
aggregate function



QSM-02084: DISTINCT clause on a duplicate sensitive aggregate function..

Answer / guest

Cause: The capability in question is not supported when the
materialized view uses the DISTINCT clause in this context.

Action: Re-phrase the query to avoid the use of the DISTINCT
clause.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-08205: ora_addr: $ORACLE_SID not set in environment

1 Answers  


ORA-26520: internal memory failure

1 Answers  


ORA-06026: NETASY: port close failure

1 Answers  


ORA-31057: Display Name of the element being inserted is null

1 Answers  


NNO-00153: warning: hint domain number has invalid name "string", hint domain ignored

1 Answers  






PLS-00715: attribute or method by name 'string' does not exist

1 Answers  


ORA-24150: evaluation context string.string does not exist

1 Answers  


ORA-38455: Expression Filter index should be created by the owner.

1 Answers  


ORA-31199: Warning in processing file string

1 Answers  


LPX-00223: external entity "~s" found in an attribute value

1 Answers  


ORA-23371: column string unknown in table string

1 Answers  


ORA-12825: explicit degree of parallelism must be specified here

1 Answers  


Categories