Interested to Buy Any Domain ? << Click Here >> for more details...
QSM-02140: agg(expr) requires correspondng SUM(expr*expr)
function
- 1 Answers
- 2845 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-02830: Segment could not be split - no free segments available
ORA-24096: invalid message state specified
ORA-14072: fixed table may not be truncated
IMG-00842: image index allocation failed
ORA-01154: database busy. Open, close, mount, and dismount not allowed now
ORA-27160: process requested to perform operation
NNL-00854: Fastest rename processing time: string
ORA-36735: A value exceeded the MAX specification
ORA-39753: unsupported use of subquery in PARTITIONED OUTER JOIN condition
TNS-12682: Login failed: the SecurID card is in next PRN mode
DRG-52107: ctxkbtc internal error
ORA-29517: recursive resolution failed for a referenced class
Oracle Errors 
