QSM-02139: agg(expr) requires correspondng agg(expr+expr)
function



QSM-02139: agg(expr) requires correspondng agg(expr+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 that same aggregate function on the same
argument added to the same argument.

Action: Add the indicated aggregate 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-39501: failed to notify CRS of a Startup/Shutdown event [number] (ignored)

1 Answers  


DGM-16991: More than one resources have name "string".

1 Answers  


PCC-02354: A file included with #include may not contain SQL statements

1 Answers  


VID-00704: invalid input format

1 Answers  


RMAN-08533: restoring blocks of datafile string

1 Answers  


ORA-02770: Total number of blocks is invalid

1 Answers  


QSM-02009: non-inner join

1 Answers  


ORA-16071: dependency archived log file not found string

1 Answers  


PROT-00006: The specified import file cannot be found

1 Answers  


ORA-36962: (XSRELTBL08) string is not a valid qualified data reference for dimension workspace object.

1 Answers  


TNS-01415: Listening Endpoints Summary...

1 Answers  


DRG-11004: duplicate or conflicting value for string

1 Answers  


Categories