Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


QSM-02140: agg(expr) requires correspondng SUM(expr*expr)
function



QSM-02140: agg(expr) requires correspondng SUM(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 the SUM function on the square of the same
argument (the argument multiplied by itself).

Action: Add the SUM function on the square of the argument.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-13274: operator invoked with non-compatible SRIDs

1 Answers  


ORA-24145: evaluation context string.string already exists

1 Answers  


ORA-24384: Application context size is not initialized

1 Answers  


TNS-00511: No listener

1 Answers  


ORA-16510: messaging error using ksrwait

1 Answers  






PLS-00452: Subprogram 'string' violates its associated pragma

1 Answers  


ORA-24132: table name string is too long

2 Answers  


ORA-23343: no match for specified conflict resolution information

1 Answers  


ORA-07218: slkhst: could not perform host operation

1 Answers  


ORA-31420: unable to submit the purge job

1 Answers  


QSM-01038: logical operator(s) could not be processed

1 Answers  


QSM-02057: ROWNUM referenced in mv

1 Answers  






Categories