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

LFI-01002: Unable to read line from file.

1 Answers  


SQL*Loader-00520: lfimknam failed for file (string)

1 Answers  


ORA-39950: invalid parameter for PLSQL warnings flag

1 Answers  


DRG-11304: function-based indexes are not supported by this indextype

1 Answers  


QSM-02151: subquery or named view in FROM list and < 9.0 compatibility

1 Answers  


TNS-00217: Total Bytes of Data : number

1 Answers  


PCC-02316: illegal operator in constant expression

1 Answers  


ORA-09777: osnpbr: cannot send break message

1 Answers  


ORA-01299: dictionary string corresponds to a different database incarnation

1 Answers  


ORA-30570: SEGMENT SPACE MANAGEMENT option already specified

1 Answers  


NNO-00626: cannot enable DEFAULT-FORWARDERS-ONLY mode, no default forwarders exist

1 Answers  


RMAN-06452: %s package upgraded to version string

1 Answers  


Categories