Oracle database error code ORA-30455 – summary contains VARIANCE without corresponding SUM & COUNT

Oracle Database Error Code ORA-30455 Description :
summary contains VARIANCE without corresponding SUM & COUNT
Error Cause:
Incremental refresh of summaries with VARIANCE(X) requires COUNT(X) and SUM(X) columns to be included in the summary definition

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:, , , , , , , , , , ,
No Comment Yet   
«
»