Interested to Buy Any Domain ? << Click Here >> for more details...
QSM-02140: agg(expr) requires correspondng SUM(expr*expr)
function
- 1 Answers
- 2922 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-10918: TABLESPACE GROUP name cannot be the same as tablespace name
ORA-30731: scope constraint not allowed on nested table column when the nested table is being created
RMAN-05001: auxiliary filename string conflicts with a file used by the target database
ORA-25307: Enqueue rate too high. Enable flow control
ORA-01880: the fractional seconds must be between 0 and 999999999
ORA-13774: insufficient privileges to select data from the workload repository
ORA-16749: Resource guard encountered errors in switchover to logical primary
NNC-00426: no such data type
ORA-25247: %s is not a recipient of specified message
ORA-31047: Could not retrieve resource data at path string
ORA-08180: no snapshot found based on specified time
TNS-02021: DIRECT_HANDOFF can be either ON or OFF.
Oracle Errors 
