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
- 2896 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 |
NZE-29005: The certificate is invalid.
NZE-29021: Secret key length is incorrect when using SSL 2.0.
TNS-01188: Listener cannot operate with incompatible transport protocols
NNL-00412: Number of requests: number
ORA-24070: cannot upgrade queue table string while it is being downgraded
QSM-02112: top level query has LEFT OUTER, RIGHT OUTER or FULL OUTER join
ORA-09702: sem_acquire: cannot acquire latch semaphore
NNO-00074: downloading region from server string
ORA-01608: cannot bring rollback segment 'string' online, its status is (string)
PLS-00603: GROUPING function supported only with GROUP BY CUBE or ROLLUP
ORA-01217: logfile member belongs to a different logfile group
RMAN-08584: copying current controlfile
Oracle Errors 
