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

DRG-10001: can not access result table string

1 Answers  


ORA-01350: must specify a tablespace name

1 Answers  


ORA-19336: Missing XML root element

1 Answers  


LCD-00111: value not in legal range [string]

1 Answers  


IMG-02004: 2FF04 - incorrect feature list specification

1 Answers  






ORA-16081: insufficient number of processes for APPLY

1 Answers  


NNO-00255: cannot initialize ROS

1 Answers  


DRG-50950: circular SQE found

1 Answers  


PCC-02035: CMD-LINE: CONFIG= option is invalid in a config file

1 Answers  


LSX-00015: failed to parse document

1 Answers  


ORA-01681: max # extents (string) reached in LOB segment in tablespace string

1 Answers  


TNS-04088: Unable to close atleast one of the connections.

1 Answers  


Categories