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-06511: PL/SQL: cursor already open

1 Answers  


RMAN-08052: cataloged controlfile copy

1 Answers  


ORA-28545: error diagnosed by Net8 when connecting to an agent

2 Answers  


ORA-22347: No changes to type specified for ALTER TYPE

1 Answers  


DRG-12210: error while adding section string

1 Answers  


TNS-04044: Specified gateways do not exist.

1 Answers  


ORA-01568: cannot set space quota on PUBLIC

1 Answers  


TNS-00007: INTCTL: unknown host

1 Answers  


ORA-35280: (SNSYN165) The format of the AGGREGATE command is: AGGREGATE varname1 [varname2 varname3 ...] USING aggmap-name [COUNTVAR intvar-name1 [intvar-name2 intvar-name3 ...]] [FUNCDATA] [THREADS #]

1 Answers  


RMAN-08115: channel string: restoring SPFILE

1 Answers  


ORA-22906: cannot perform DML on expression or on nested table view column

1 Answers  


ORA-01356: active logminer sessions found

1 Answers  


Categories