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-01339: logfile is too old

1 Answers  


ORA-14297: Index block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION

1 Answers  


ORA-14174: only a <parallel clause> may follow COALESCE PARTITION|SUBPARTITION

1 Answers  


ORA-16594: %s process discovered that DMON process does not exist

1 Answers  


EXP-00000: Export terminated unsuccessfully

1 Answers  






ORA-22997: VARRAY | OPAQUE stored as LOB is not specified at the table level

1 Answers  


PLS-00604: aggregate function is not allowed here

1 Answers  


LFI-00133: Trying to create file string that already exists.

1 Answers  


ORA-23413: table "string"."string" does not have a materialized view log

1 Answers  


ORA-08454: more than one S symbol specified in picture mask

1 Answers  


QSM-01565: equivalence, string, cannot compute measure, string, in the query

1 Answers  


SQL*Loader-00435: invalid constant value string for nested table column string

1 Answers  


Categories