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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PLS-00150: found: string but expected : INTEGER

1 Answers  


ORA-19763: compatibility version string is higher than maximum allowed: string

1 Answers  


TNS-01066: Presentation: string

1 Answers  


QSM-02018: subquery present in the WHERE clause

1 Answers  


ORA-01034: ORACLE not available

1 Answers  






DRG-11719: Broader Term hierarchy too deep

1 Answers  


TNS-00000: Not An Error

1 Answers  


ORA-12438: repeated policy option: string

1 Answers  


ORA-24302: host connection in use by another thread

1 Answers  


ORA-36984: (XSRELGID04) A value cannot be inserted into dimension workspace object.

1 Answers  


ORA-38431: could not evaluate subexpression "string" for rowid "string"

1 Answers  


ORA-02245: invalid ROLLBACK SEGMENT name

1 Answers  


Categories