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

LPX-00655: Invalid output comment '~S'.

1 Answers  


ORA-12720: operation requires database is in EXCLUSIVE mode

1 Answers  


RMAN-05504: at least two redo log files or groups must be specified for this command

1 Answers  


NZE-28825: No cryptographic engine function specified.

1 Answers  


RMAN-08009: channel string: starting archive log backupset

1 Answers  






PLS-00592: the type of a object table must be an object type

1 Answers  


ORA-02174: Missing required thread number

1 Answers  


RMAN-06595: platform name 'string' does not match database platform name 'string'

1 Answers  


ORA-23360: only one materialized view for master table "string" can be created

1 Answers  


LRM-00121: 'string' is not an allowable value for 'string'

1 Answers   TCS,


ORA-24145: evaluation context string.string already exists

1 Answers  


ORA-07757: slemcc: invalid handle

1 Answers  


Categories