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-02139: agg(expr) requires correspondng agg(expr+expr)
function



QSM-02139: 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 same
argument added to the same argument.

Action: Add the indicated aggregate function to the select list.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-30656: column type not supported on external organized table

1 Answers  


LPX-00256: invalid element declaration

1 Answers  


ORA-12017: cannot alter primary key mview 'string' to a rowid mview

1 Answers  


NZE-29026: Decryption failure

1 Answers  


ORA-16092: dependent archive log destination is not active

1 Answers  


RMAN-08580: channel string: starting datafile copy

1 Answers  


ORA-30029: no active undo tablespace assigned to instance

1 Answers  


ORA-00094: %s requires an integer value

1 Answers  


TNS-12600: TNS: string open failed

1 Answers  


ORA-16127: stalled waiting for additional transactions to be applied

1 Answers  


QSM-00765: cannot validate user-defined workload because table string.string is invalid.

1 Answers  


ORA-30115: error when processing an environment variable

1 Answers  


Categories