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...


QSM-02140: agg(expr) requires correspondng SUM(expr*expr)
function



QSM-02140: agg(expr) requires correspondng SUM(expr*expr) function..

Answer / guest

Cause: The capability in question is not supported when the
materialized view uses certain aggregate functions but omits
an invocation of the SUM function on the square of the same
argument (the argument multiplied by itself).

Action: Add the SUM function on the square of the argument.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-30041: Cannot grant quota on the tablespace

1 Answers  


ORA-19902: incarnation key string not found

1 Answers  


UDI-00002: invalid username or password

1 Answers  


ORA-14611: Duplicate subpartition name string in template

1 Answers  


TNS-00019: INTCTL: error initializing the national language interface

1 Answers  


RMAN-06457: UNTIL scn (string) is ahead of last scn in archived logs (string)

1 Answers  


TNS-12658: ANO service required but TNS version is incompatible

1 Answers  


ORA-12638: Credential retrieval failed

1 Answers  


TNS-00077: the argument field

1 Answers  


ORA-29903: error in executing ODCIIndexFetch() routine

1 Answers  


ORA-27102: out of memory

1 Answers  


ORA-07605: szprv: $ASCTOID failure

1 Answers  


Categories