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

RMAN-05504: at least two redo log files or groups must be specified for this command

1 Answers  


ORA-24307: invalid length for piece

1 Answers  


QSM-00789: the string string is invalid for directive string

1 Answers  


ORA-25532: MTTR specified is too large: string

1 Answers  


TNS-12657: No algorithms installed

1 Answers  


DRG-10520: failed to drop index: string

1 Answers  


ORA-00056: DDL lock on object 'string.string' is already held in an incompatible mode

1 Answers  


PCB-00317: Group item host variables are Oracle extensions

1 Answers  


ORA-13425: function not implemented

1 Answers  


RMAN-06512: copy will be obsolete on date string

1 Answers  


ORA-12400: invalid argument to facility error handling

1 Answers  


hi, In maintenance order release The following error exists, pl any body give the sollution for this, The error is "System status WCRE is active (ACT #2)" Thanks kbramesha

1 Answers  


Categories