ORA-30455: summary contains VARIANCE without corresponding SUM & COUNT

oracle

ORA-30455: summary contains VARIANCE without corresponding SUM & COUNT
Cause: Incremental refresh of summaries with VARIANCE(X) requires COUNT(X) and SUM(X) columns to be included in the summary definition
Action: Make sure that the required columns are part of the summary definition if incremental refresh capability is desired

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/