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-09976: skxfqdini: Error Creating Port

1 Answers  


ORA-09853: snyRemovePort: bad return code from request.

1 Answers  


ORA-07474: snclrd: close error, unable to close sgadef.dbf file.

1 Answers  


ORA-02766: Invalid maximum of request descriptors

1 Answers  


PLS-00388: undefined column 'string' in subquery

1 Answers  


SQL-02140: An unnamed connection already exists

1 Answers  


RMAN-06463: Backup set key string cannot be backed up by proxy.

1 Answers  


TNS-12513: TNS:service handler found but it has registered for a different protocol

1 Answers  


ORA-30181: integer in argument index is not immediately followed by )

1 Answers  


PCC-02424: The number of values and host variables does not match

1 Answers  


SQL*Loader-00647: Integer to number conversion error

1 Answers  


ORA-16014: log string sequence# string not archived, no available destinations

1 Answers  


Categories