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

AMD-00110: parameter string of "string" not valid

1 Answers  


ORA-12402: invalid format string: string

1 Answers  


SQL*Loader-00135: Invalid argument for RESUMABLE

1 Answers  


PCB-00580: Previous use of host variable "string" uses different indicator

1 Answers  


ORA-09799: File label retrieval failed.

1 Answers  






ORA-04067: not executed, string does not exist

1 Answers  


ORA-26716: message limit reached

1 Answers  


ORA-00608: testing error [string] [string] [string] [string] [string]

1 Answers  


ORA-16704: Cannot set the property because it is read-only

1 Answers  


SQL*Loader-00810: error creating external table: string

1 Answers  


ORA-00604: error occurred at recursive SQL level string

1 Answers  


ORA-02160: index-organized table can not contain columns of type LONG

1 Answers  


Categories