QSM-02041: nested aggregate function



QSM-02041: nested aggregate function..

Answer / guest

Cause: The capability in question is not supported when the
materialized view nests an aggregate function invocation as
an argument to another aggregate function.

Action: Re-phrase the query to avoid the nested aggregate
function invocation.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-38750: FLASHBACK DATABASE may not be performed using a dispatcher.

1 Answers  


ORA-24439: success with PLSQL compilation warning

1 Answers  


RMAN-06495: must explicitly specify DBID with SET DBID command

1 Answers  


ORA-00237: snapshot operation disallowed: controlfile newly created

1 Answers  


ORA-28559: FDS_CLASS_NAME is string, FDS_INST_NAME is string

1 Answers  


LSX-00119: value is not valid restriction of parent's minLength

1 Answers  


RMAN-06730: no channel to restore a backup of the SPFILE

1 Answers  


DRG-52210: error while registering value for attribute: string

1 Answers  


ORA-31050: Access denied

1 Answers  


ORA-31468: cannot process DDL change record

1 Answers  


ORA-09284: sllfop: cannot allocate read buffer

1 Answers  


O2U-00202: Invalid data passed to function

1 Answers  


Categories