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

PCC-02328: undefined struct member

1 Answers  


PLS-00455: cursor 'string' cannot be used in dynamic SQL OPEN statement

1 Answers  


NNL-00538: stop|shutdown [<server_list>] : stop one or more Names servers

1 Answers  


ORA-01647: tablespace 'string' is read only, cannot allocate space in it

2 Answers  


DRG-11515: not enough text key values

1 Answers  






ORA-24088: AQ Agent string does not exist

1 Answers  


ORA-01626: rollback segment number 'string' cannot handle more transactions

1 Answers  


ORA-38755: Flashback is already turned on for this tablespace.

1 Answers  


TNS-04022: %s parameter string set to string.

1 Answers  


QSM-02048: outer join in mv

1 Answers  


ORA-01023: Cursor context not found (Invalid cursor number)

1 Answers  


ORA-12926: FORCE LOGGING option already specified

1 Answers  


Categories