| activating Online Index Build [message #120228] |
Wed, 18 May 2005 09:50  |
mbexel
Messages: 2
Registered: May 2005
|
Junior Member |
|
|
hello,
I am trying to run:
ALTER INDEX magicuser.SYMPTOM_DAPK REBUILD ONLINE;
and I get the error message:
ORA-00439: Fonction non activée : Online Index Build
(function not activated).
I do have the ALTER ANY INDEX privilege.
How do I activate this function?
My Oracle server (Win NT) conf:
-------------------------------
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
|
|
|
|
| Re: activating Online Index Build [message #120400 is a reply to message #120228] |
Thu, 19 May 2005 08:27  |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
Is online rebuilding an EE thing and you on standard?
Is that a regular index or a function based index or a bitmap index?
I don't know about your specific problem, but 9.2.0.1 has a lot of bugs. Patch on up to the latest 9iR2 version, or upgrade to 10gR1 if you can.
|
|
|
|
|
|
| Re: activating Online Index Build [message #120569 is a reply to message #120228] |
Fri, 20 May 2005 08:58 |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
|
Sorry for abbreviating. What I meant was that some functionality (depending on the exact task and the exact oracle version) requires Oracle Enterprise Edition, while some things can be done in Oracle Standard Edition. Glad you got it solved.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
...