Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-30452: cannot compute AVG(X), VARIANCE(X) or STDDEV(X),
without COUNT(X) or SUM(X)
- 1 Answers
- 2768 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: Incremental refresh of summaries requires a COUNT(X)
column in order to incrementally refresh AVG(X). It requires
both SUM(X) and COUNT(X) columns in order to in refresh
STDDEV(X) or VARIANCE(X)
Action: Make sure that the required columns are part of the
summary definition if incremental refresh capability is desired.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-39127: unexpected error from call to string string
ORA-16806: Supplemental logging is not turned on.
ORA-38477: attribute set cannot be derived from an evolved type or a subtype.
DRG-11127: inconsistent index policy with trained rule
ORA-29552: verification warning: string
SQL*Loader-00107: Invalid maximum number of discards
TNS-00115: Could not allocate pump global buffers
TNS-12214: TNS:missing local communities entry in TNSNAV.ORA
ORA-06503: PL/SQL: Function returned without value
ORA-28116: insufficient privileges to do direct path access
DRG-11843: Gateway Timeout
ORA-30929: ORDER SIBLINGS BY clause not allowed here
Oracle Errors 
