| how to rebuild index [message #139768] |
Thu, 29 September 2005 09:16  |
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  |
 |
Mahesh Rajendran
Messages: 10708
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?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
