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

ORA-13414: invalid pyramid parameter

1 Answers  


SQL*Loader-00434: Can not load LOB/XML in a nested table along with the parent table.

1 Answers  


RMAN-06090: error while looking up controlfile copy: string

1 Answers  


PLS-00368: in RAISE statement, 'string' must be an exception name

1 Answers  


ORA-29546: badly formed resource: string

1 Answers  






ORA-39129: Object type string not imported. Name conflicts with the master table

1 Answers  


ORA-25192: invalid option for an index-organized table

1 Answers  


ORA-32581: missing or invalid password

1 Answers  


ORA-32738: Hang analysis aborted due to failed memory copy

1 Answers  


ORA-38725: specified name "string" does not match actual "string"

1 Answers  


ORA-07618: $IDTOASC failed translating a secrecy level

1 Answers  


LSX-00018: invalid schema context

1 Answers  


Categories