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-02298: cannot validate (string.string) - parent keys not found

2 Answers  


ORA-01541: system tablespace cannot be brought offline; shut down if necessary

1 Answers  


QSM-01112: WHERE clause of mv, string, is more restrictive than query

1 Answers  


RMAN-08093: specifying current controlfile for proxy backup

1 Answers  


ORA-15069: ASM file 'string' not accessible; timed out waiting for lock

1 Answers  






ORA-12525: TNS:listener has not received client's request in time allowed

1 Answers  


ORA-01178: file string created before last CREATE CONTROLFILE, cannot recreate

1 Answers  


SQL*Loader-02026: the load was aborted because SQL Loader cannot continue.

1 Answers  


SQL*Loader-00416: SDF clause for field string in table string references a non existent field.

1 Answers  


ORA-13441: GeoRaster metadata SRS error

1 Answers  


NNL-00201: Shutdown occurs in string

1 Answers  


ORA-24368: OCI mutex counter non-zero when freeing a handle

1 Answers  


Categories