QSM-02140: agg(expr) requires correspondng SUM(expr*expr)
function



QSM-02140: agg(expr) requires correspondng SUM(expr*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 square of the same
argument (the argument multiplied by itself).

Action: Add the SUM function on the square of the argument.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-14409: inserted partition key is outside specified subpartition

1 Answers  


NNL-00516: Displays complete server status

1 Answers  


QSM-01124: set operator materialized view, string, doesn't have a marker column

1 Answers  


DRG-11601: URL store: bad syntax on request for string

1 Answers  


ORA-29703: error occurred in global enqueue service operation

1 Answers  


ORA-03210: DBMS_ADMIN_PACKAGE invalid option specification

1 Answers  


ORA-33425: (EIFMAKEF15) CAUTION: Exporting NTEXT objects using string for the EIF file character set can cause loss of data. To preserve all NTEXT data, export using the UTF8 character set for the EIF file.

1 Answers  


ORA-09796: szrbuild: malloc of role name failed.

1 Answers  


DRG-11613: URL store: connection refused to host specified by string

1 Answers  


ORA-15049: diskgroup "string" contains string error(s)

1 Answers  


LSX-00341: ENTITY or ENTITIES type may only be used in attributes

1 Answers  


VID-00703: unable to read video data

1 Answers  


Categories