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

RMAN-00556: could not open CMDFILE "string"

2 Answers  


ORA-07278: splon: ops$username exceeds buffer length.

1 Answers  


ORA-09708: soacon: failed to bind socket to port.

1 Answers  


ORA-29552: verification warning: string

1 Answers  


ORA-15102: invalid POWER expression

1 Answers  






ORA-33024: (XSAGDNGL11) AGGMAP workspace object contains duplicate information.

1 Answers  


ORA-38710: Flashback log version string is incompatible with ORACLE version string.

1 Answers  


KUP-04065: error processing LOBFILE for field string

1 Answers  


NCR-03017: NCRO: Transport type RSLV not supported

1 Answers  


ORA-19816: WARNING: Files may exist in string that are not known to database.

1 Answers  


TNS-00143: Illegal PREFERRED_CMANAGERS entry in TNSNAV.ORA

1 Answers  


ORA-24013: invalid value string, RETRY_DELAY should be non-negative

1 Answers  


Categories