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-01150: cannot prevent writes - file string has online backup set

1 Answers  


ORA-16542: unrecognized operation

1 Answers  


TNS-00137: Failed to get TNS error message file entry

1 Answers  


ORA-06423: NETCMN: Error in receiving data

1 Answers  


ORA-12439: invalid combination of policy options

1 Answers  


QSM-01107: Partition Containment Tracking (PCT) rewrite is not allowed

1 Answers  


LPX-00234: namespace prefix "~S" is not declared

2 Answers  


NNL-00832: Deletes refused, name is a topology name: number

1 Answers  


ORA-09979: skxfqhsnd: Error Sending a message to another endpoint

1 Answers  


LSX-00290: invalid enumeration choice "~S"

1 Answers  


ORA-12197: TNS:keyword-value resolution error

1 Answers  


ORA-39031: invalid filter name string

1 Answers  


Categories