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-24033: no recipients for message

1 Answers  


ORA-12215: TNS:poorly formed PREFERRED_NAVIGATORS Addresses in TNSNAV.ORA

1 Answers  


ORA-07844: sllfop: LIB$GET_VM failure

1 Answers  


DRG-11700: thesaurus string already exists

1 Answers  


ORA-01715: UNIQUE may not be used with a cluster index

1 Answers  






ORA-01118: cannot add any more database files: limit of string exceeded

1 Answers  


ORA-39952: only numbers can be specified as range values

1 Answers  


LFI-01511: unlink() failed(OSD errno = string) in string.

1 Answers  


SQL*Loader-00934: Incorrect data file string specified for table string

1 Answers  


ORA-19720: Error occurred when converting an OCI number into an SCN

1 Answers  


ORA-13786: missing SQL text of statement object "string" for tuning task "string"

1 Answers  


ORA-22973: size of object identifier exceeds maximum size allowed

1 Answers  


Categories