QSM-02140: agg(expr) requires correspondng SUM(expr*expr)
function
- 1 Answers
- 2223 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-19680: some blocks not recovered. See trace file for details
RMAN-04025: unable to generate a temporary file
SQL*Loader-00115: Invalid direct path option
ORA-36908: (XSAGDNGL46) In AGGMAP workspace object, MODEL workspace object has the repeating dimension with the previous model.
ORA-16509: the request timed out
ORA-28541: Error in HS init file on line number.
ORA-27488: unable to set string because string was/were already set
ORA-13866: Client identifier must be specified
ORA-26576: cannot acquire SR enqueue
ORA-02259: duplicate UNIQUE/PRIMARY KEY specifications
PLS-00156: Null constraints not supported for object attributes.
RMAN-03099: job cancelled at user request
Oracle Errors 
