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

PCC-02428: Buffer type is incompatible with LOB type

1 Answers  


ORA-13028: Invalid Gtype in the SDO_GEOMETRY object

2 Answers  


ORA-32012: failure in processing system parameters from restored SPFILE

1 Answers  


ORA-00385: cannot enable Very Large Memory with new buffer cache parameters

1 Answers  


TNS-12699: Native service internal error

1 Answers  


NNL-00935: Requests refused, SINGLE-VALUE violation: number

1 Answers  


ORA-34143: (MXCGPUT02) You cannot assign values to SURROGATE workspace object because it is type INTEGER.

1 Answers  


ORA-34296: (MXDCL36) A NUMBER dimension must be defined with a fixed precision and scale, using the form NUMBER(precision) or NUMBER(precision, scale).

1 Answers  


ORA-01270: %s operation is not allowed if STANDBY_PRESERVES_NAMES is true

1 Answers  


KUP-04051: error processing column string in row number for datafile string

1 Answers  


IMP-00046: using FILESIZE value from export file of string

1 Answers  


ORA-28656: incomplete attribute specification

1 Answers  


Categories