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

LFI-00145: User buffer too short.

1 Answers  


ORA-01527: error while reading file

1 Answers  


ORA-25121: MINIMUM EXTENT value greater than maximum extent size

1 Answers  


ORA-31447: cannot create change tables in the SYS schema

1 Answers  


ORA-32821: subscriber queue and exception queue must have same payload type

1 Answers  






ORA-24804: Lob read/write functions called while another OCI LOB read/write streaming is in progress

1 Answers  


ORA-08467: error converting Oracle number to string

1 Answers  


DRG-11712: multiple Broader Terms for term string

1 Answers  


ORA-23313: object group "string"."string" is not mastered at string

1 Answers  


ORA-26563: renaming this table is not allowed

1 Answers  


ORA-30198: reserved for future use

1 Answers  


ORA-07844: sllfop: LIB$GET_VM failure

1 Answers  


Categories