ORA-30452: cannot compute AVG(X), VARIANCE(X) or STDDEV(X),
without COUNT(X) or SUM(X)
- 1 Answers
- 2439 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-23386: replication parallel push cannot create slave processes
ORA-00021: session attached to some other process; cannot switch session
ORA-10632: Invalid rowid
ORA-19203: Error occurred in DBMS_XMLGEN processingstring
ORA-19642: incremental-start SCN is string
ORA-26057: Conversion is not necessary for this direct path stream.
ORA-09850: soacon: Archmon unable to lock named pipe.
ORA-09766: osnmop: buffer allocation failure.
SQL*Loader-00265: Unable to get default character set name.
NNO-00251: missing administrative region parameter string
RMAN-06221: Removing automatic instance
ORA-03231: the INITIAL extent may not be deallocated
Oracle Errors 
