Re: How can I identify the database

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_at_yahoo.com> wrote:

> Probably this
>
> select * from product_component_version;
>
> Regards
>
> Raj
>
> --- On Thu, 24/9/09, Eriovaldo Andrietta <ecandrietta_at_gmail.com> wrote:
>
> > From: Eriovaldo Andrietta <ecandrietta_at_gmail.com>
> > Subject: How can I identify the database
> > To: "ORACLE-L" <oracle-l_at_freelists.org>
> > 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
> >
> >
> >
> >
> >
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l