• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6462
  • Last Modified:

Alter Index Online Problem ORA-00439

When I run "ALTER INDEX ADMINTEST_PRIMARY REBUILD ONLINE;" -- I get this error, "An error occurred when executing the SQL command:
ORA-00439: feature not enabled: Online Index Build [SQL State=67000, DB Errorcode=439] "

After running "select * from v$option", here is the table I see.

Partitioning      FALSE
Objects      TRUE
Real Application Clusters      FALSE
Advanced replication      FALSE
Bit-mapped indexes      FALSE
Connection multiplexing      TRUE
Connection pooling      TRUE
Database queuing      TRUE
Incremental backup and recovery      FALSE
Instead-of triggers      TRUE
Parallel backup and recovery      FALSE
Parallel execution      FALSE
Parallel load      TRUE
Point-in-time tablespace recovery      FALSE
Fine-grained access control      FALSE
Proxy authentication/authorization      TRUE
Change Data Capture      FALSE
Plan Stability      TRUE
Online Index Build      FALSE
Coalesce Index      FALSE
Managed Standby      FALSE
Materialized view rewrite      FALSE
Materialized view warehouse refresh      FALSE
Database resource manager      FALSE
Spatial      FALSE
Visual Information Retrieval      FALSE
Export transportable tablespaces      FALSE
Transparent Application Failover      FALSE
Fast-Start Fault Recovery      FALSE
Sample Scan      TRUE
Duplexed backups      FALSE
Java      TRUE
OLAP Window Functions      TRUE
Block Media Recovery      FALSE
Fine-grained Auditing      FALSE
Application Role      FALSE
Enterprise User Security      FALSE
Oracle Data Guard      FALSE
Oracle Label Security      FALSE
Heap segment compression      FALSE
Join index      FALSE
Trial Recovery      FALSE
Oracle Data Mining      FALSE
Online Redefinition      FALSE
Streams      FALSE
Very Large Memory      FALSE
File Mapping      FALSE

This DB is running Oracle 9i ( on windows server 2003.  

My question, why can't I build tune the indexes online?  When Oracle was installed, was this feature not enabled?  Which feature is it in correlation to the v$option?  If I need to enable it, how do I accomplish this?
2 Solutions
It looks like you are running Oracle Standard Edition and not Enterprise edition. Online Index Rebuild is a feature of Enterprise Edition only. To check the edition, you can query the view v$version.

gdlp2004Author Commented:
This is after I run:  select * from v$version;

Oracle9i Release - Production
PL/SQL Release - Production
CORE      Production
TNS for 32-bit Windows: Version - Production
NLSRTL Version - Production
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

vishal68  is correct!!!!!!

Also upgrade it to if have access to metalink.

SQL> select * from v$version;

Oracle9i Enterprise Edition Release - Production
PL/SQL Release - Production
CORE       Production
TNS for 32-bit Windows: Version - Production
NLSRTL Version - Production
gdlp2004Author Commented:
Can I install Enterprise edition on top of standard and the upgrade to Or do I have to rebuild my server??  Obviously the database has to be shutdown to do this, correct??  Keep in mind this is my production database.  Please advise the best way to go enterprise ed (yes, i already have a license for it).  Thanks.

But I will rather advise you to install Standart Ediotion on a spare computer and to put there a cold backup of the Production. After that make experiments there to be sure that it works.
gdlp2004Author Commented:
Still didn't answer my question. Can I install Enterprise edition on top of standard and the upgrade to Or do I have to rebuild my server??. Thanks.
I think this is risky. You have also to upgrade the dictionary and there is no waranty that this will succeed.
If this is developmnent it is better do not take this risk.
Try to migrate to Enterprise Editition using Export/Import. I have posted many times on EE how to migrate using this method.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now