QSM-02084: DISTINCT clause on a duplicate sensitive
aggregate function



QSM-02084: DISTINCT clause on a duplicate sensitive aggregate function..

Answer / guest

Cause: The capability in question is not supported when the
materialized view uses the DISTINCT clause in this context.

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

AMD-00114: PROCEDURE string, internal error

1 Answers  


ORA-06031: NETDNT: connect failed, unrecognized object name

1 Answers  


ORA-25301: cannot specify recipient list during enqueue

1 Answers  


ORA-14516: subpartition corrupt. all rows do not fall within subpartition bounds

1 Answers  


DRG-50807: failed to commit

1 Answers  






ORA-38103: Invalid column in the UPDATE SET Clause: string

1 Answers  


RMAN-03020: asynhronous RPC test will take 1 minute

1 Answers  


LFI-00135: Unable to remove temporary file.

1 Answers  


IMG-00716: source image format does not support process options

1 Answers  


ORA-23503: error occurred during IAS instantiation

1 Answers  


ORA-27044: unable to write the header block of file

1 Answers  


RMAN-03033: current log archived

1 Answers  


Categories