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

ORA-13040: failed to subdivide tile

1 Answers  


ORA-39078: unable to dequeue message for agent string from queue "string"

1 Answers  


LPX-00249: invalid external ID declaration

1 Answers  


QSM-00768: the search condition is invalid for the requested operation

1 Answers  


ORA-35062: (QFGET01) Duplicate files found for extension number number of EIF file string.

1 Answers  






NNL-00930: Requests refused, unknown data type: number

1 Answers  


TNS-01078: Opened name lookup file: string

1 Answers  


SQL*Loader-00277: Local file specification overrides global file specification.

1 Answers  


ORA-23453: requested operation is not supported on top flavor

1 Answers  


ORA-08178: illegal SERIALIZABLE clause specified for user INTERNAL

1 Answers  


ORA-24093: AQ agent string not granted privileges of database user string

1 Answers  


ORA-29339: tablespace block size string does not match configured block sizes

1 Answers  


Categories