Re: How can I identify the database

 I am sorry.
 But each e-mail that I read I understand more about my issue.  After researchs and command executions... the actual issue is:

    I found that the BITMAP index is a payed resource, that for running it is required LICENSE.

    So, what I need to identify is :

         The instalattion has LICENSE for use of BITMAP INDEX. This is the issue.

    Because, I got information that the Oracle user must pay to use BITMAP.     It is avaialable in all Oracle versions, like : Oracle Express, Standard and Enterprise, but need to pay for use it.

   My question is:

       How to identify if an installed Oracle instance is authorized to use BITMAP.
       Where can I get this information in the database, running an script in order to make decision if I create a BITMAP INDEX or a NORMAL INDEX.

Best Regards
Eriovaldo

On Thu, Sep 24, 2009 at 8:17 PM, Jared Still <jkstill_at_gmail.com> wrote:

> You don't actually need to know the version to accomplish this.
> Just try initially creating a bitmap index inside a PL/SQL routine.
>
> If it succeeds then you create bitmap indexes.
>
> If it fails, then catch the exception and set a bit or a flag
> that lets you know that bitmap indexes are not available
> and btree must be used instead.
>
> It seems from your post that this is kind of what you have in mind.
>
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
> Oracle Blog: http://jkstill.blogspot.com
> Home Page: http://jaredstill.com
>
>
>
>
> On Thu, Sep 24, 2009 at 4:10 PM, Eriovaldo Andrietta <
> ecandrietta_at_gmail.com> wrote:
>
>> 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_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