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?
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook 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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.