Oracle Solution for Error ora-30454
ORA-30454: summary contains STDDEV without corresponding SUM & COUNT
What triggered the Error:
Incremental refresh of summaries with STDDEV(X) requires COUNT(X) and SUM(X) columns to be included in the summary definitionWhat should we do to fix it:
Make sure that the required columns are part of the summary definition if incremental refresh capability is desired.
If this was not sufficient go over to:
Oracle Official Support Knowledge Center
Or maybe those geeks at: StackOverflow Board
Or maybe those geeks at: StackOverflow Board
