ORA-30454: summary contains STDDEV without corresponding SUM
& COUNT



ORA-30454: summary contains STDDEV without corresponding SUM & COUNT..

Answer / guest

Cause: Incremental refresh of summaries with STDDEV(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-04017: invalid value string (length = string) for parameter max_dump_file_size

1 Answers  


ORA-23376: node string is not compatible with replication version "string"

1 Answers  


PCC-02417: Illegal type conversion between attribute and host variable

1 Answers  


RMAN-06707: could not initialize for output file: "string"

1 Answers  


LFI-00120: Unable to parse root filename string.

1 Answers  






ORA-14096: tables in ALTER TABLE EXCHANGE PARTITION must have the same number of columns

1 Answers  


ORA-23395: object "string"."string" of type "string" does not exist or is invalid

1 Answers  


ORA-12713: Character data loss in NCHAR/CHAR conversion

1 Answers  


PLS-01405: Under ANSI's grammar, numeric data represented in exponent notationmust use an uppercase E

1 Answers  


ORA-16777: unable to find the destination entry of a standby in V$ARCHIVE_DEST

1 Answers  


ORA-08330: Printing not supported

1 Answers  


QSM-02038: Partition Change Tracking (PCT) is enabled

1 Answers  


Categories