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-12919: Can not drop the default permanent tablespace

1 Answers  


ORA-09706: slsget: get_process_stats error.

1 Answers  


LFI-00100: Unable to perform operation, file not opened in string.

1 Answers  


PCC-01014: "VARYING" not supported with PIC N PICTURE clause

1 Answers  


QSM-00502: OCI error

1 Answers  






ORA-31625: error changing username from string to string

1 Answers  


ORA-06710: TLI Driver: send interrupt break message failed

1 Answers  


ORA-16759: Resource guard unable to start logical apply engine with initial SCN

1 Answers  


RMAN-05505: auxiliary filename conversion of 'string' exceeds maximum length of string

1 Answers  


QSM-02185: no partition key or PMARKER in select list

1 Answers  


TNS-00533: Connection dissolved or not yet made

1 Answers  


ORA-25250: Cannot specify a remote recipient for the message

1 Answers  


Categories