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-02138: agg(expr) requires correspondng agg(expr*expr)
function



QSM-02138: agg(expr) requires correspondng agg(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 that same aggregate function on the square
of the same argument.

Action: Add an invocation of the same aggregate function on
the square of the same argument (that is, the argument
multiplied by itself).

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-37106: (XSVPART06) Invalid partition name number.

1 Answers  


ORA-24153: rule set string.string already exists

1 Answers  


SQL*Loader-00525: OCI return status: success

1 Answers  


IMG-00581: output format does not support the specified contentFormat

1 Answers  


ORA-39050: parameter string is incompatible with parameter string

1 Answers  


ORA-02339: invalid column specification

1 Answers  


ORA-02197: file list already specified

1 Answers  


ORA-30515: suspend triggers cannot have BEFORE type

1 Answers  


ORA-14044: only one partition may be moved

1 Answers  


DRG-50904: weight string outside valid range 0.1 to 10.0

1 Answers  


ORA-32812: subscriber string does not exist

1 Answers  


ORA-38743: Time/SCN is in the future of the database.

1 Answers  


Categories