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

TNS-01113: save_config_on_stop can either be ON or OFF

1 Answers  


PLS-00387: INTO variable cannot be a database object

1 Answers  


NNO-00702: cache checkpointing disabled

1 Answers  


ORA-06956: Failed to get local host name

1 Answers  


ORA-29275: partial multibyte character

1 Answers  


LCD-00215: parameter files nested too deep [string]

1 Answers  


ORA-29839: failed to validate implementation type

1 Answers  


RMAN-20503: DELETE cannot delete expired objects - run CROSSCHECK or DELETE EXPIRED

1 Answers  


QSM-01123: self-join algorithm could not resolve multiple instances

1 Answers  


ORA-02071: error initializing capabilities for remote database string

1 Answers  


O2F-00338: Illegal or missing package name

1 Answers  


ORA-02300: invalid value for OIDGENERATORS

1 Answers  


Categories