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



QSM-02131: agg(expr) requires correspondng SUM(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 same argument.

Action: Add the SUM function to the select list.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-22933: cannot change object with type or table dependents

1 Answers  


DRG-51022: undefined error in stemmer

1 Answers  


ORA-08412: error encountered in WMSGBSIZ, size for WMSGBLK is not big enough for warning message

1 Answers  


NNO-00328: server has reset statistic counters to zero

1 Answers  


ORA-38952: Source database not 10.0.0.0 compatible

1 Answers  


ORA-07415: slpath: allocation of memory buffer failed.

1 Answers  


NNL-00515: Deletes a name and its data

1 Answers  


NPL-00303: uninitialized ASN.1 class attribute

1 Answers  


NNC-00430: Database not accessible

1 Answers  


ORA-22997: VARRAY | OPAQUE stored as LOB is not specified at the table level

1 Answers  


RMAN-08519: channel string: scanning datafilecopy string

1 Answers  


ORA-28508: invalid value string for Heterogeneous Services initialization parameter string

1 Answers  


Categories