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

SQL*Loader-00931: OCI error while binding variable for column string in table string

1 Answers  


NZE-29009: Bad encrypted key length when using SSL 2.0

1 Answers  


NNL-01075: Contact string

1 Answers  


TNS-01102: TNS application contacted was not the listener

1 Answers  


ORA-00348: single-process redo failure. Must abort instance

1 Answers  






ORA-08458: invalid format parameter

1 Answers  


PCC-02324: found variable name used as a typedef name

1 Answers  


ORA-38764: flashback not started; datafile string enabled threads are different

1 Answers  


PLS-00379: CASE statements are not included in this release of PL/SQL

1 Answers  


ORA-36632: (XSDUNION01) The concat dimension workspace object is not currently defined as UNIQUE.

1 Answers  


PCC-00081: Scale specification not allowed for given datatype

1 Answers  


DRG-50863: string assignment failed

1 Answers  


Categories