Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


ORA-30452: cannot compute AVG(X), VARIANCE(X) or STDDEV(X),
without COUNT(X) or SUM(X)



ORA-30452: cannot compute AVG(X), VARIANCE(X) or STDDEV(X), without COUNT(X) or SUM(X)..

Answer / guest

Cause: Incremental refresh of summaries requires a COUNT(X)
column in order to incrementally refresh AVG(X). It requires
both SUM(X) and COUNT(X) columns in order to in refresh
STDDEV(X) or VARIANCE(X)

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-19851: OS error while managing auxiliary database string

1 Answers  


ORA-32740: The requested operation cannot be proceeded

1 Answers  


ORA-19761: block size string is not valid for change tracking file

1 Answers  


TNS-00288: Navigator: Failed to Disable Interchange

1 Answers  


ORA-15070: maximum number of files string exceeded in diskgroup "string"

1 Answers  


ORA-03206: maximum file size of (string) blocks in AUTOEXTEND clause is out of range

2 Answers  


PLS-00367: a RAISE statement with no exception name must be inside an exception handler

1 Answers  


ORA-16583: bad Data Guard Connection Process DRCX state

1 Answers  


ORA-06706: TLI Driver: service not found

1 Answers  


ORA-24811: less data provided for writing than indicated

1 Answers  


NNL-00001: request argument "string" is invalid

1 Answers  


LSX-00112: facet "~S" duplicated

1 Answers  


Categories