QSM-02086: mv uses the MIN or MAX aggregate functions



QSM-02086: mv uses the MIN or MAX aggregate functions..

Answer / guest

Cause: The capability in question is not supported when the
materialized view uses the MIN or MAX function.

Action: Re-phrase the query to avoid the use of the MIN or
MAX functions.

Please add more information about this Error

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-25241: cannot change correlation ID from string to string without FIRST_MESSAGE option

1 Answers  


LCD-00112: illegal integer radix specification [string]

1 Answers  


TNS-03602: Insufficient arguments. Usage: trcroute <address>

1 Answers  


ORA-26536: refresh was aborted because of conflicts caused by deferred transactions

1 Answers  


ORA-06911: CMX: t_event returns ERROR

1 Answers  






ORA-39060: table(s) dropped because of conflict with master table

1 Answers  


NID-00304: Datafile string - reverted

1 Answers  


DRG-12203: section group string does not exist

1 Answers   Four Design,


ORA-15109: conflicting protection attributes specified

1 Answers  


CLSS-00099: logfile open failed for string, err string

1 Answers  


ORA-07606: szprv: $CHKPRO failure

1 Answers  


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

1 Answers  


Categories