QSM-02140: agg(expr) requires correspondng SUM(expr*expr)
function
- 1 Answers
- 2241 Views
- I also Faced
- E-Mail Answers
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 |
ORA-01251: Unknown File Header Version read for file number string
ORA-08002: sequence string.CURRVAL is not yet defined in this session
ORA-19705: tag value exceeds maximum length of string characters
ORA-03001: unimplemented feature
ORA-02190: keyword TABLES expected
NNL-00513: Shows or sets the server's auto-refresh failure retry interval
ORA-30513: cannot create system triggers of INSTEAD OF type
ORA-33052: (XSAGDNGL25) AGGMAP workspace object is a dimensioned AGGMAP; it can only be used to aggregate like-dimensioned variables.
LSX-00248: invalid duration "~S"
PCB-00628: Buffer type is incompatible with LOB type
TNS-04207: Trace Assistant Internal ERROR: Packet Length
ORA-28025: missing or null external name
Oracle Errors 
