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

ORA-29843: indextype should support atleast one operator

1 Answers  


TNS-00501: Cannot allocate memory

1 Answers  


NNL-01062: Cache checkpoint file name: string

1 Answers  


ORA-23425: invalid materialized view identifier string

1 Answers  


ORA-12657: No algorithms installed

1 Answers  






ORA-25449: invalid variable name: string

1 Answers  


ORA-39727: COMPATIBLE must be set to 10.0.0.0.0 or higher

1 Answers  


NID-00142: Only changing database name, previous attempt changed dbid to number

1 Answers  


ORA-02299: cannot validate (string.string) - duplicate keys found

2 Answers  


SQL-02157: Source or destination lob is invalid

1 Answers  


ORA-03290: Invalid truncate command - missing CLUSTER or TABLE keyword

1 Answers  


LSX-00253: branch is empty

1 Answers  


Categories