Alter Index Online Problem ORA-00439

Posted on 2006-03-29
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?
Question by:gdlp2004
    LVL 19

    Expert Comment

    LVL 7

    Accepted Solution

    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.


    Author Comment

    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
    LVL 47

    Expert Comment

    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

    Author Comment

    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.
    LVL 47

    Expert Comment


    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.

    Author Comment

    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.
    LVL 47

    Assisted Solution

    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.

    Featured Post

    Live: Real-Time Solutions, Start Here

    Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

    Join & Write a Comment

    Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
    Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
    Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
    Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now