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


QSM-02138: agg(expr) requires correspondng agg(expr*expr)
function



QSM-02138: 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 square
of the same argument.

Action: Add an invocation of the same aggregate function on
the square of the same argument (that is, the argument
multiplied by itself).

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-16094: database shutdown during archival operation

1 Answers  


ORA-00266: name of archived log file needed

1 Answers  


ORA-02362: error closing file: string

1 Answers  


PLS-00352: Unable to access another database 'string'

1 Answers  


ORA-02833: Server was unable to close file

1 Answers  






ORA-25190: an index-organized table maintenance operation may not be combined with other operations

1 Answers  


NNL-00901: CONTENT ERROR responses sent: number

1 Answers  


ORA-07701: sksatln: internal exception: output buffer too small

1 Answers  


ORA-38105: Delete not yet supported when Update row-migration is possible

1 Answers  


ORA-22884: object modification failed

1 Answers  


PLS-01905: : character string buffer too small

1 Answers  


ORA-19200: Invalid column specification

1 Answers  






Categories