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-32101: cannot create OCI Environment

1 Answers  


RMAN-12013: multiple records for string channel number found in catalog

1 Answers  


NID-00422: Change of database ID failed during validation - database is intact.

1 Answers  


ORA-00105: too many dispatcher configurations

1 Answers  


PLS-00567: cannot pass NULL to a NOT NULL constrained formal parameter

1 Answers  


ORA-33000: (AGOPEN00) AGGMAP workspace object cannot be accessed because it was compiled by a more recent version of string.

1 Answers  


SQL-02108: Invalid descriptor passed to run-time library

1 Answers  


ORA-30034: Undo tablespace cannot be specified as temporary tablespace

1 Answers  


ORA-00059: maximum number of DB_FILES exceeded

2 Answers  


ORA-17502: ksfdcre:string Failed to create file string

1 Answers  


ORA-19700: device type exceeds maximum length of string

1 Answers  


ORA-31653: unable to determine job operation for privilege check

1 Answers  


Categories