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

NNL-01057: Foreign data items cached: number

1 Answers  


ORA-19639: file string is more current than this incremental backup

1 Answers  


RMAN-07502: List of Files Unknown to the Database

1 Answers  


ORA-24438: Invalid Authentication Handle specified.

1 Answers  


ORA-26060: Can not convert type identifier for column string

1 Answers  


NCR-03025: NCRO: Failed to make LIST connection(s)

1 Answers  


LSX-00274: invalid padding in base64-encoded binary

1 Answers  


ORA-08343: srclose: failed to close a redo server connection

1 Answers  


ORA-00448: normal completion of background process

1 Answers  


ORA-24019: identifier for string too long, should not be greater than string characters

1 Answers  


ORA-38426: attribute set assigned to an expression set may not be dropped

1 Answers  


ORA-25461: rule set not specified

1 Answers  


Categories