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


QSM-02131: agg(expr) requires correspondng SUM(expr) function



QSM-02131: agg(expr) requires correspondng SUM(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 same argument.

Action: Add the SUM 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

Why we can't perform DML operations on Materialized views???

1 Answers   CGI,


NCR-02006: NCRF: Invalid floating point representation received

1 Answers  


ORA-13191: failed to read SDO_ORDCNT value

1 Answers  


PLS-00351: Not logged onto database 'string'

1 Answers  


NNC-00423: invalid data item syntax code string

1 Answers  






ORA-25134: keyword TABLE expected

1 Answers  


ORA-13027: unable to read dimension definition from string

1 Answers  


ORA-13381: table:string not found in network:string

1 Answers  


ORA-32303: mviews with user-defined types cannot reference multiple master sites

1 Answers  


ORA-00034: cannot string in current PL/SQL session

1 Answers  


RMAN-06740: database name is not specified

1 Answers  


ORA-31633: unable to create master table "string.string"

1 Answers  






Categories