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 |
IMP-00091: Above error occurred on the following function and object: string. Remaining PL/SQL blocks for this object will be skipped.
ORA-02349: invalid user-defined type - type is incomplete
ORA-02278: duplicate or conflicting MAXVALUE/NOMAXVALUE specifications
ORA-01076: multiple logons per process not yet supported
ORA-22950: cannot ORDER objects without MAP or ORDER method
TNS-12680: Native services disabled but required
ORA-07305: ksmcsg: illegal database buffer size.
ORA-15178: directory 'string' is not empty; cannot drop this directory
ORA-39952: only numbers can be specified as range values
ORA-32741: Hang analysis already going on
NZE-28776: Output buffer supplied is too small.
ORA-25238: too many recipients specified for message destination string