Tuesday, 22 May 2012

ORA-30455: summary contains VARIANCE without corresponding SUM COUNT

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.

No comments:

Post a Comment