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


QSM-02054: DISTINCT clause in select list in mv



QSM-02054: DISTINCT clause in select list in mv..

Answer / guest

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

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

IMP-00091: Above error occurred on the following function and object: string. Remaining PL/SQL blocks for this object will be skipped.

1 Answers  


ORA-02349: invalid user-defined type - type is incomplete

1 Answers  


ORA-02278: duplicate or conflicting MAXVALUE/NOMAXVALUE specifications

1 Answers  


ORA-01076: multiple logons per process not yet supported

1 Answers  


ORA-22950: cannot ORDER objects without MAP or ORDER method

1 Answers  






TNS-12680: Native services disabled but required

1 Answers  


ORA-07305: ksmcsg: illegal database buffer size.

1 Answers  


ORA-15178: directory 'string' is not empty; cannot drop this directory

1 Answers  


ORA-39952: only numbers can be specified as range values

1 Answers  


ORA-32741: Hang analysis already going on

1 Answers  


NZE-28776: Output buffer supplied is too small.

1 Answers  


ORA-25238: too many recipients specified for message destination string

1 Answers  






Categories