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-31055: A null XMLType element cannot be inserted into RESOURCE_VIEW

1 Answers  


ORA-01909: REUSE keyword expected

1 Answers  


RMAN-06514: archived logs required to recover from this copy will not be kept

1 Answers  


DRG-12412: missing or invalid Template Processor attribute (string)

1 Answers  


ORA-22604: TDS handle already generated

1 Answers  






LPX-00101: parameter-entity markup cannot be split up

1 Answers  


TNS-02022: show rules: Show rules that are currently in effect

1 Answers  


ORA-12551: TNS:missing keyword

1 Answers  


ORA-19018: Invalid character in XML tag 'string'

1 Answers  


ORA-01577: cannot add log file 'string' - file already part of database

1 Answers  


ORA-16132: An error occurred during activation of the standby.

1 Answers  


ORA-13043: failed to read metadata from the <layer>_SDOLAYER table

1 Answers  


Categories