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-02402: PLAN_TABLE not found

1 Answers  


TNS-04019: Starting Oracle Connection Manager instance string. Please wait...

1 Answers  


DRG-13303: value of wildcard offset must be in the range string..string, at line string

1 Answers  


ORA-36612: (XSLMS01) An application attempted to retrieve a non-existent user message. (Product: value, Facility: value, Message Number: value)

1 Answers  


ORA-09340: Specified ORACLE_SID is either invalid or too long

1 Answers  


LPX-00406: object of incorrect type passed to the function

1 Answers  


PCC-02133: CMD-LINE: Error in string processing function

1 Answers  


TNS-00105: Could not initialize tracing

1 Answers  


PLS-01418: Subquery cannot include set operators in ANSI's grammar

1 Answers  


DRG-10750: unknown parameter string

1 Answers  


ORA-07705: sksaprs: device name buffer too small

1 Answers  


ORA-31406: change source string is referenced by a change set

1 Answers  


Categories