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

ORA-16717: clearing parameter LOG_ARCHIVE_DUPLEX_DEST failed

1 Answers  


DRG-10701: preference string.string already exists

1 Answers  


NNL-00260: Server-generated requests now do not require authoritative answers

1 Answers  


ORA-07257: spdcr: translation error expanding program name.

2 Answers  


ORA-29340: export file appears to be corrupted: [string] [string] [string]

1 Answers  


TNS-01057: Program name: string

1 Answers  


ORA-39078: unable to dequeue message for agent string from queue "string"

1 Answers  


ORA-30359: Query rewrite is not supported on SYS materialized views

1 Answers  


EXP-00104: datatype (string) of column string in table string.string is not supported, table will not be exported

1 Answers  


ORA-25300: Cannot drop buffer for queue with buffered subscribers

1 Answers  


DRG-12011: Authentication failed - retry?

1 Answers  


ORA-38720: Missing log file number.

1 Answers  


Categories