gdlp2004
asked on
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.
PARAMETER VALUE
--------------------------
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/authorizati
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
OLAP 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 (9.2.0.1) 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?
Thanks.
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.
PARAMETER VALUE
--------------------------
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/authorizati
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
OLAP 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 (9.2.0.1) 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?
Thanks.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
This is after I run: select * from v$version;
BANNER
------------------
Oracle9i Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production
BANNER
------------------
Oracle9i Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production
vishal68 is correct!!!!!!
Also upgrade it to 9.2.0.7 if have access to metalink.
SQL> select * from v$version;
BANNER
--------------------------
Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
PL/SQL Release 9.2.0.7.0 - Production
CORE 9.2.0.7.0 Production
TNS for 32-bit Windows: Version 9.2.0.7.0 - Production
NLSRTL Version 9.2.0.7.0 - Production
Also upgrade it to 9.2.0.7 if have access to metalink.
SQL> select * from v$version;
BANNER
--------------------------
Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
PL/SQL Release 9.2.0.7.0 - Production
CORE 9.2.0.7.0 Production
TNS for 32-bit Windows: Version 9.2.0.7.0 - Production
NLSRTL Version 9.2.0.7.0 - Production
ASKER
Can I install Enterprise edition on top of standard and the upgrade to 9.2.0.7??? 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 9.2.0.7 (yes, i already have a license for it). Thanks.
https://www.experts-exchange.com/questions/21764011/ORA-00439-feature-not-enabled-Partitioning.html
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.
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.
ASKER
Still didn't answer my question. Can I install Enterprise edition on top of standard and the upgrade to 9.2.0.7??? Or do I have to rebuild my server??. Thanks.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
looking for install_options.bat