Home » RDBMS Server » Performance Tuning » how to rebuild index
how to rebuild index [message #139768] Thu, 29 September 2005 09:16 Go to next message
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
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?

Previous Topic: Statspack
Next Topic: SQL Query with many joins
Goto Forum:
  


Current Time: Thu Mar 28 13:16:46 CDT 2024