Re: How can I identify the database
- From: Jared Still <jkstill@xxxxxxxxx>
- To: ecandrietta@xxxxxxxxx
- Date: Thu, 24 Sep 2009 16:17:58 -0700
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:
