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-03209: DBMS_ADMIN_PACKAGE invalid file/block specification

1 Answers  


RMAN-06488: restore from autobackup does not allow any other modifiers

1 Answers  


TNS-00249: Unable to read network configuration data from file string with error: string

1 Answers  


ORA-00256: cannot translate archive destination string string

1 Answers  


ORA-00449: background process 'string' unexpectedly terminated with error string

1 Answers  






ORA-01028: internal two task error

1 Answers  


ORA-29516: Aurora assertion failure: string

1 Answers  


DRG-10504: primary key is required when using the DETAIL_DATASTORE

1 Answers  


ORA-24073: cannot specify RETENTION_TIME on exception queue string.string

1 Answers  


NNL-00933: Requests refused, OTHER-DATA violation: number

1 Answers  


RMAN-00555: target database connect string must be specified

1 Answers  


ORA-06004: NETASY: dialogue file open failure

1 Answers  


Categories