Tuesday 22 May 2012

ORA-30453: summary contains AVG without corresponding COUNT

ORA-30453: summary contains AVG without corresponding COUNT

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

No comments:

Post a Comment