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;

Report message to a moderator

- 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: 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?

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 03 08:58:55 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.