QSM-02134: agg(expr) requires correspondng MAX(expr) function



QSM-02134: agg(expr) requires correspondng MAX(expr) function..

Answer / guest

Cause: The capability in question is not supported when the
materialized view uses certain aggregate functions but omits
an invocation of the MAX function on the same argument.

Action: Add the MAX function to the select list.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-22311: type for attribute "string" does not exist

1 Answers  


ORA-04052: error occurred when looking up remote object stringstringstringstringstring

1 Answers  


ORA-06009: NETASY: dialogue filename too long

1 Answers  


NCR-04021: NCRR: Pickler errors

1 Answers  


ORA-07650: sigunc: $GETJPIW failure

1 Answers  


ORA-27160: process requested to perform operation

1 Answers  


ORA-30198: reserved for future use

1 Answers  


NNL-00243: Processing of modification requests is now enabled

1 Answers  


ORA-23318: a ddl failure has occurred

1 Answers  


ORA-06140: NETTCP: no such user

1 Answers  


ORA-26041: DATETIME/INTERVAL datatype conversion error

1 Answers  


PLS-00372: In a procedure, RETURN statement cannot contain an expression

1 Answers  


Categories