Great, There are lot of tables that constains data related to product database. My actual issue is: I have a script that creates index, so , I cannot create BITPMAP index when the instance is Oracle Express. My idea was: a.) identify the product database b.) is it Oracle Express then CREATE INDEX I_001 ON .... if different from Oracle Express then CREATE BITMAP INDEX I_001 ON ... In fact I need to identify the product only for solving the script mentioned above. I also had the following idea: a.) create the BITMAP index and try to use it. If I got error using it THEN DROP INDEX I_001 ... CREATE INDEX I_001 ... (no bitmap) END This is my purpose. Regards Eriovaldo On Thu, Sep 24, 2009 at 1:31 PM, Rajaram Subramanian < rajaram.subramanian@xxxxxxxxx> wrote: > Probably this > > select * from product_component_version; > > Regards > > Raj > > --- On Thu, 24/9/09, Eriovaldo Andrietta <ecandrietta@xxxxxxxxx> wrote: > > > From: Eriovaldo Andrietta <ecandrietta@xxxxxxxxx> > > Subject: How can I identify the database > > To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx> > > Date: Thursday, 24 September, 2009, 11:41 AM > > Hi, > > > > How can I identify if the database is an Oracle > > Enterprise Version or an Oracle Express Version. > > Consider that I don´t have access privilige in the > > v$database and others v$. > > > > Is there another way ? > > > > > > Regards > > Eriovaldo > > > > > > > > > > > > > >