Re: How can I identify the database
- From: Eriovaldo Andrietta <ecandrietta@xxxxxxxxx>
- To: Gints Plivna <gints.plivna@xxxxxxxxx>
- Date: Fri, 25 Sep 2009 15:48:05 -0300
Friends,
Here is the script that I did.
This will solve my issue. I hope that it can help someone in the future. :)
DECLARE
v_success BOOLEAN;
BEGIN
v_success := TRUE;
BEGIN
EXECUTE IMMEDIATE 'CREATE BITMAP INDEX idx_f1 ON PODEAPAGAR(COLUNA1)
TABLESPACE tbsind';
EXCEPTION
WHEN OTHERS THEN
IF SUBSTR(sqlerrm, 1, 9) = 'ORA-00439' THEN
v_success := FALSE;
DBMS_OUTPUT.PUT_LINE(SQLERRM);
DBMS_OUTPUT.PUT_LINE('Resource not available');
END IF;
END;
IF NOT v_success THEN
EXECUTE IMMEDIATE 'CREATE INDEX idx_lot_f1 ON PODEAPAGAR(COLUNA1)
TABLESPACE tbsind';
ELSE
DBMS_OUTPUT.PUT_LINE('BITMAP index successfuly created');
END IF;
END;
Thanks a lot .
Regards
Eriovaldo
On Fri, Sep 25, 2009 at 8:36 AM, Gints Plivna <gints.plivna@xxxxxxxxx>wrote:
> > I found that the BITMAP index is a payed resource, that for running
> it
> > is required LICENSE.
> Since when? And where it is written?
> That's not true.
> See licensing guide
>
> http://download.oracle.com/docs/cd/E11882_01/license.112/e10594/editions.htm#BABDJGGI
> for complete info what is and what isn't extra cost option.
>
> Actually from installed instance with extra cost options (which are
> available only for enterprise edition) you CANNOT understand whether
> option is legally installed and used or not. This information you have
> to find in some adminsitration and licensing docs between your
> organization and reseller. There is no way to get to know that from
> installed instance because installation process has nothing to do with
> license documents.
>
> Gints Plivna
> http://www.gplivna.eu
>
Other related posts:
