how to rebuild index [message #139768] |
Thu, 29 September 2005 09:16 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
c_gajen
Messages: 8 Registered: September 2005 Location: Nagpur
|
Junior Member |
|
|
hello
i want to rebuild all index.
i use the command
alter index index_name rebuild online;
i get error index dose ot exists;
|
|
|
Re: how to rebuild index [message #139773 is a reply to message #139768] |
Thu, 29 September 2005 09:35 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/42800.jpg) |
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
Error is self explanatory.
Either the index does not exist in the database
or
You are looking into the wrong schema.
alter index username.index_name rebuild online;
And why are you rebuilding these indices?
|
|
|