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-17503: ksfdopn:string Failed to open file string

1 Answers  


NZE-29227: Certificate is expired.

1 Answers  


ORA-12595: TNS:no confirmation

1 Answers  


ORA-27198: skgfpvl: sbtpcvalidate returned error

1 Answers  


ORA-15069: ASM file 'string' not accessible; timed out waiting for lock

1 Answers  


ORA-23327: imported deferred rpc data does not match string of importing db

1 Answers  


ORA-02285: duplicate START WITH specifications

1 Answers  


ORA-31670: Username argument must be specified and non-null.

1 Answers  


CLSS-02202: voting device access took an excessive amount of time. (string sec)

1 Answers  


IMG-00720: image processing internal error

1 Answers  


ORA-12707: error while getting create database NLS parameter string

1 Answers  


ORA-28277: LDAP search, while authenticating global user with passwords, failed.

1 Answers  


Categories