Re: How can I identify the database

Friends,

 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@xxxxxxxxx> 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@xxxxxxxxx> 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@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
>>> >
>>> >
>>> >
>>> >
>>> >
>>>
>>>
>>>
>>>
>>
>

Other related posts: