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
- 2834 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-07614: $CHANGE_CLASS failed in retrieving the user's process label
PLS-00245: Formals used in the 'parameters' clause must appear exactly once
ORA-14007: missing LESS keyword
ORA-30733: cannot specify rowid constraint on scoped ref column
IMG-00707: unable to access image data
SQL*Loader-00558: attempt to use SKIP parameter with linked-in loader
QSM-01083: query text not available - possible inline view
TNS-00523: Previous operation was busy
ORA-01525: error in renaming data files
ORA-23300: %s
KUP-04019: illegal length found for VAR record in file string
ORA-30678: too many open connections
Oracle Errors 
