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-02114: no GROUP BY clause, no aggregates and not >= 9.0
compatibility



QSM-02114: no GROUP BY clause, no aggregates and not >= 9.0 compatibility..

Answer / guest

Cause: The capability in question is not supported when the
materialized view has no GROUP BY clause, no aggregates and
compatibility mode is less than 9.0.

Action: Re-phrase the query to avoid the include a GROUP BY
clause or an aggregate function. Or set compatibility mode
to 9.0 or greater.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

LFI-00142: Unable to delete an existing file [string][string] not owned by Oracle.

1 Answers  


ORA-39708: component 'string' not a string component

1 Answers  


NID-00141: No database name specified, previous attempt used string

1 Answers  


PLS-00646: MAP or ORDER method must be defined in the root of the subtype hierarchy

1 Answers  


ORA-06733: TLI Driver: failed to receive disconnect

1 Answers  


ORA-13025: polygon does not close

1 Answers  


ORA-13129: HHCODE column string not found

1 Answers  


ORA-03202: the scan limit specification is invalid

1 Answers  


ORA-36991: (XSRELGID08) The level relation and level order valueset provide inconsistent level mappings.

1 Answers  


DRG-52113: improper Japanese string string of length number

1 Answers  


ORA-00438: %s Option not installed

1 Answers  


ORA-01655: unable to extend cluster string.string by string in tablespace string

1 Answers  


Categories