Home » RDBMS Server » Performance Tuning » activating Online Index Build
activating Online Index Build [message #120228] Wed, 18 May 2005 09:50 Go to next message
mbexel
Messages: 2
Registered: May 2005
Junior Member
hello,

I am trying to run:
ALTER INDEX magicuser.SYMPTOM_DAPK REBUILD ONLINE;

and I get the error message:
ORA-00439: Fonction non activée : Online Index Build
(function not activated).
I do have the ALTER ANY INDEX privilege.

How do I activate this function?

My Oracle server (Win NT) conf:
-------------------------------
Oracle9i Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production
Re: activating Online Index Build [message #120400 is a reply to message #120228] Thu, 19 May 2005 08:27 Go to previous messageGo to next message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
Is online rebuilding an EE thing and you on standard?

Is that a regular index or a function based index or a bitmap index?

I don't know about your specific problem, but 9.2.0.1 has a lot of bugs. Patch on up to the latest 9iR2 version, or upgrade to 10gR1 if you can.

Re: activating Online Index Build [message #120508 is a reply to message #120228] Fri, 20 May 2005 04:45 Go to previous messageGo to next message
mbexel
Messages: 2
Registered: May 2005
Junior Member
to reply to smartin:

Is online rebuilding an EE thing and you on standard?
sorry, but i don't understand this question...
Anyway I found the info about this function on
http://www.oracle-base.com/articles/9i/HighAvailabilityEnhancements9i.php

Is that a regular index or a function based index or a bitmap index?
regular index.

I must admit that i just found out this function is not installed on my server ( "The Online Index Build option is not installed"), so
Embarassed ...

Thanks for the hints.
Re: activating Online Index Build [message #120569 is a reply to message #120228] Fri, 20 May 2005 08:58 Go to previous message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
Sorry for abbreviating. What I meant was that some functionality (depending on the exact task and the exact oracle version) requires Oracle Enterprise Edition, while some things can be done in Oracle Standard Edition. Glad you got it solved.
Previous Topic: Statspack for 9i on 8.1.6
Next Topic: Performance problem!!
Goto Forum:
  


Current Time: Sat Sep 19 02:07:12 CDT 2020