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-00170: the SQL statement in an OPEN statement or FOR loop must be a SELECT

1 Answers  


ORA-29664: Unable to generate the helper class for the defined type

1 Answers  


ORA-24307: invalid length for piece

1 Answers  


NNL-00573: load_tnsnames [<file>, ... ] : load tnsnames into ONames

1 Answers  


ORA-16751: Resource guard encountered errors in switchover to primary

1 Answers  






ORA-29290: invalid offset specified for seek

1 Answers  


CLSR-01003: Error number encountered during mounting database

1 Answers  


ORA-06702: TLI Driver: cannot allocate context area

1 Answers  


ORA-36962: (XSRELTBL08) string is not a valid qualified data reference for dimension workspace object.

1 Answers  


ORA-06031: NETDNT: connect failed, unrecognized object name

1 Answers  


ORA-31434: purge is currently running

1 Answers  


ORA-23325: parameter type is not string

1 Answers  


Categories