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-38730: Invalid SCN/TIMESTAMP expression.

1 Answers  


ORA-32305: RepAPI materialized views with user-defined types are not supported

1 Answers  


ORA-09320: szrfc: unable to obtain the list of valid OS roles

1 Answers  


NCR-03016: NCRO: Message has bad address

1 Answers  


ORA-38950: Source platform string not cross platform compliant

1 Answers  






ORA-02835: Server unable to send signal to client

1 Answers  


NNL-01003: NON LEAF responses received: number

1 Answers  


ORA-31455: nothing to ALTER

1 Answers  


DRG-10606: server failed to access the DML Queue

1 Answers  


RMAN-06566: target database incarnation not found in control file

1 Answers  


ORA-19688: control file autobackup format(string) for string does not have %F

1 Answers  


SQL*Loader-00116: Error prompting for password

1 Answers  


Categories