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
- 2837 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-16539: task element not found
ORA-22806: not an object or REF
ORA-19647: non-zero LEVEL cannot be specified when INCREMENTAL is FALSE
PLS-00599: SAMPLE percentage must be in the range [0.000001,100)
NZE-29249: an unrecognized state was passed to a cryptographic function
ORA-28540: internal result set error
ORA-01336: specified dictionary file cannot be opened
ORA-24351: invalid date passed into OCI call
ORA-31634: job already exists
ORA-01117: adding file 'string' with illegal block size: string; limit is string
ORA-21600: path expression too long
ORA-28673: Merge operation not allowed on an index-organized table
Oracle Errors 
