ORA-00439: feature not enabled: Online Index Build

If you are getting ORA-00439 for a different feature, you may want to check out other postings concerning this family of error messages.

I was trying to execute this DDL, on my hosted database, a 10.1.0.5 standard edition running on solaris:

alter index CONTEXT_STEM_IDX rebuild online;

ORA-00439: feature not enabled: Online Index Build

This statement is supposed to rebuild a context index online, that is without preventing users from issuing queries against this index while the operation is in progress.

Unfortunately online index build will only work on an Enterprise Edition and a feature comparison list made by Don Burleson back in 2003, presumably for Oracle 9i, seems to support this interpretation.

I tried to locate an official Oracle feature map and indeed i found two, a detailed Oracle Product Feature by Edition and also a web page, but, unfortunately, i can't tell whether this optional feature is listed or not, the closest match i could spot is called parallel index build.
While searching for "feature comparison", i stumbled also on this interesting whitepaper concerning Oracle 10G R2 Online Data Reorganization & Redefinition where there is absolutely no mention of which database edition supports which feature.

If anyone can come up with something more precise on this subject, i'll most delighted to include a link to the document.

At any rate, a less demanding:

alter index CONTEXT_STEM_IDX rebuild;

worked well and rebuilt my index in a few seconds.

If you can't afford to run the risk of blocking any users, you may want to consider rebuilding the index during off-peak hours, by running a scheduled job.

ORA-00439: feature not enabled: Block Change Tracking

If you are getting ORA-00439 for a different feature, you may want to check out other postings concerning this family of error messages.

I got this error when i tried executing:

ALTER DATABASE ENABLE BLOCK CHANGE TRACKING
ORA-00439: feature not enabled: Block Change Tracking

I was really disappointed because i had just finished reading this article on Oracle Magazine and i was eager to try it out.

So i turned up to the oracle documentation and in the Licensing Information Guide i finally found out that block change tracking, allegedly called optimized incremental backup, was not available to Standard Editions, but limited to the Enterprise one. Or at least that was my understanding of the licensing information.

Don't you find that at times there is too much marketing in technical publications?

Awaiting comments

---

ORA-00439: funzione non abilitata:
ORA-00439: función no activada:
ORA-00439: característica no habilitada:
ORA-00439: Fonction non activée :
ORA-00439: Funktion nicht aktiviert:
ORA-00439: μη ενεργοποιημένη δυνατότητα:
ORA-00439: facilitet ikke aktiveret:
ORA-00439: funktionen är inte aktiverad:
ORA-00439: funksjon ikke aktivert:
ORA-00439: ominaisuus ei ole käytössä:
ORA-00439: a szolgáltatás nincs engedélyezve:
ORA-00439: caracteristică neactivată:
ORA-00439: Functionaliteit is niet geactiveerd: .
ORA-00439: recurso não ativado:
ORA-00439: Funcionalidade não activada:
ORA-00439: Не задействована функциональная возможность:
ORA-00439: není aktivována funkce:
ORA-00439: funkcia nie je aktivovaná:
ORA-00439: funkcja nie jest włączona:
ORA-00439: özellik etkinleştirilmedi: