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-01616: instance string (thread string) is open - cannot disable

1 Answers  


ORA-03001: unimplemented feature

1 Answers  


ORA-32630: multiple assignment in automatic order MODEL

1 Answers  


ORA-12154: TNS:could not resolve the connect identifier specified

1 Answers  


NNL-00204: Cancelled shutdown

1 Answers  






LSX-00142: invalid sub-element "~1S" for element "~2S"

1 Answers  


RMAN-05017: no copy of datafile number found to recover

0 Answers  


ORA-13014: a topology identifier outside the range of 1 to 8 was specified

1 Answers  


NCR-02009: NCRF: Unable to open trace file

1 Answers  


DRG-11846: Response Is Stale

1 Answers  


PLS-00407: '*' not allowed here; a list of columns is required

1 Answers  


PCC-00013: Unable to open include file "string" at line number in file string

1 Answers  


Categories