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

DRG-11002: missing value for string

1 Answers  


TNS-12654: Authentication conversion failed

1 Answers  


ORA-39954: DEFERRED is required for this system parameter

1 Answers  


ORA-01934: circular role grant detected

1 Answers  


NZE-28821: No input buffer provided.

1 Answers  


NZE-29042: Read buffer is not empty.

1 Answers  


ORA-25183: index-organized table top index segment is in a different tablespace

1 Answers  


NCR-01003: NCRS: Read error.

1 Answers  


RMAN-08057: channel string: backup cancelled because all files were skipped

1 Answers  


ORA-23456: flavor string does not contain "string"

1 Answers  


ORA-32838: exceeded maximum number of properties

1 Answers  


NCR-03002: NCRO: Maximum number of contexts has been reached

1 Answers  


Categories