ORA-30453: summary contains AVG without corresponding COUNT



ORA-30453: summary contains AVG without corresponding COUNT..

Answer / guest

Cause: Incremental refresh of summaries with AVG(X) requires
a COUNT(X) column 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

SQL-02147: ANSI Dynamic occurrence value out of range

1 Answers  


ORA-01122: database file string failed verification check

1 Answers  


IMG-00823: boundary queue pop failed

1 Answers  


ORA-16552: An error occurred when generating the CLIENT OPERATION table.

1 Answers  


TNS-00263: Navigator: Request Failed

1 Answers  






PCC-02321: only subtraction between two pointers is permitted

2 Answers  


ORA-12496: cannot change existing level, category, or release numbers

1 Answers  


ORA-25242: cannot change subscriber name from string to string without FIRST_MESSAGE option

1 Answers  


ORA-39702: database not open for UPGRADE or DOWNGRADE

1 Answers  


ORA-24330: internal OCI error

1 Answers  


SQL*Loader-00512: Unable to free read buffer

1 Answers  


ORA-13209: internal error while reading SDO_INDEX_METADATA table

1 Answers  


Categories