We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now


Alter Index Online Problem ORA-00439

gdlp2004 asked
Medium Priority
Last Modified: 2012-06-22
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?
Watch Question

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.


Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts


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
Top Expert 2008

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


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.
Top Expert 2008


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.


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.
Top Expert 2008
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.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.