Oracle Error ORA-30453: summary contains AVG without corresponding COUNT

Oracle Error Message

ORA-30453: summary contains AVG without corresponding COUNT

Reason for the Error

Incremental refresh of summaries with AVG(X) requires a COUNT(X) column 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.