How to Solve :
cannot compute AVG(X)'s tag archives
Oracle Database Error Code ORA-30452 Description :
cannot compute AVG(X), VARIANCE(X) or STDDEV(X), without COUNT(X) or SUM(X)
Error 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)
How to Solve :
Make sure that the required columns are part of the summary definition if incremental refresh capability is desired.
Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes Etiketler: ora - 30452, VARIANCE(X) or STDDEV(X), without COUNT(X) or SUM(X), 30452, about oracle ORA-30452 error, cannot compute AVG(X), help ORA-30452 about, ORA-30452 error code, ORA-30452 problem, Oracle 9i 10g 11g, Oracle Database Server Error Messages, Oracle Error Codes, oracle number 30452 error code, oracle ORA-30452 example
No Comment Yet
No Comment Yet
Search Oracle Error Codes and Descriptions:
Recent Entries
- Oracle database error code ORA-31604 – invalid string parameter “string” for object type string in function string
- Oracle database error code ORA-29961 – too many warnings occurred in the execution of ODCIIndex DDL routine
- Oracle database error code ORA-31603 – object “string” of type string not found in schema “string”
- Oracle database error code ORA-29960 – line string, string
- Oracle database error code ORA-31602 – parameter string value “string” in function string inconsistent with string
- Oracle database error code ORA-29964 – missing ADD or DROP keyword
- Oracle database error code ORA-31606 – XML context number does not match any previously allocated context