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

QSM-01031: materialized view, string, is stale in TRUSTED integrity mode

1 Answers  


ORA-36980: (XSRELGID02) Variable workspace object must have a numeric data type.

1 Answers  


ORA-02253: constraint specification not allowed here

3 Answers  


RMAN-06142: DEVICE TYPE cannot be specified with this command

1 Answers  


ORA-19698: %s is from different database: id=string, db_name=string

1 Answers  


ORA-25450: error string during evaluation of rule set string.string

1 Answers  


ORA-31014: Attempted to delete the root container

1 Answers  


ORA-32165: Cannot get XA environment

1 Answers  


PCC-02338: structure contains a nested struct or union

1 Answers  


ORA-07509: scgfal: $deq parent lock unexpected return

1 Answers  


ORA-38957: Target database not 10.0.0.0 compatible

1 Answers  


ORA-24272: initialization value must be either F or T

1 Answers  


Categories