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

Oracle Error Message

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

Reason for the Error

Incremental refresh of summaries with VARIANCE(X) requires COUNT(X) and SUM(X) columns to be included in the summary definition

Solution

Make sure that the required columns are part of the summary definition if incremental refresh capability is desired.