ORA-30452: cannot compute AVG(X), VARIANCE(X) or STDDEV(X),
without COUNT(X) or SUM(X)
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-19851: OS error while managing auxiliary database string
ORA-32740: The requested operation cannot be proceeded
ORA-19761: block size string is not valid for change tracking file
TNS-00288: Navigator: Failed to Disable Interchange
ORA-15070: maximum number of files string exceeded in diskgroup "string"
ORA-03206: maximum file size of (string) blocks in AUTOEXTEND clause is out of range
PLS-00367: a RAISE statement with no exception name must be inside an exception handler
ORA-16583: bad Data Guard Connection Process DRCX state
ORA-06706: TLI Driver: service not found
ORA-24811: less data provided for writing than indicated
NNL-00001: request argument "string" is invalid
LSX-00112: facet "~S" duplicated