Interested to Buy Any Domain ? << Click Here >> for more details...
QSM-02140: agg(expr) requires correspondng SUM(expr*expr)
function
- 1 Answers
- 2861 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-24323: value not allowed
NNL-00296: Controller's local trace level changed from number to number
TNS-01418: Proxy service "string" has number instance(s).
ORA-16021: session string destination cannot be the same as session string destination
ORA-25258: cannot register for notifications on an 8.0 style exception queue
DRG-10800: query failed: string string string
ORA-04053: error occurred when validating remote object stringstringstringstringstring
ORA-28663: Logging/Nologging attribute can not be specified in the statement ALTER TABLE ADD OVERFLOW
DRG-10583: TRUNCATE INDEX failed: string
ORA-37129: (XSCCOMP04) The AGGMAP workspace object cannot be used to aggregate the VARIABLE workspace object. All static MODEL statements must precede all RELATION statments over the bases of the COMPRESSED COMPOSITE.
ORA-16603: Data Guard broker detected a mismatch in configuration ID.
ORA-27488: unable to set string because string was/were already set
Oracle Errors 
