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

PROC-00006: User does not have permission to perform a cluster registry operation on this key.

1 Answers  


ORA-14025: PARTITION may not be specified for a materialized view or a materialized view log

1 Answers  


ORA-29278: SMTP transient error: string

1 Answers  


ORA-19763: compatibility version string is higher than maximum allowed: string

1 Answers  


ORA-09316: szrpc: unable to verify password for role

1 Answers  


NZE-28853: Initialization failure

1 Answers  


PLW-05004: identifier string is also declared in STANDARD or is a SQL builtin

1 Answers  


LPX-00285: invalid Unicode surrogate ~X ~X

1 Answers  


ORA-15177: cannot operate on system aliases

1 Answers  


ORA-24130: table string does not exist

1 Answers  


SQL*Loader-00479: REF directive for column string expects number arguments; found number.

1 Answers  


SQL*Loader-00284: Warning: Input data file string specified multiple times.

1 Answers  


Categories