Home » RDBMS Server » Performance Tuning » How to rebuild indexes
How to rebuild indexes [message #267258] Wed, 12 September 2007 20:04 Go to next message
coolboy2005in
Messages: 12
Registered: July 2007
Location: Herndon
Junior Member
We have a table that is by some application 24/7 and we made some structural changes so all the indexes on that table became invalid.

How can we rebuild the index on this table if it is being used continuously by the users/application?

I have oracle 10g R2 and Platform is RHEL4.

Report message to a moderator

Re: How to rebuild indexes [message #267291 is a reply to message #267258] Thu, 13 September 2007 00:03 Go to previous message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you have structural changes on the table then it is not used continously (unless you used dbms_redefinition).
You can use "online" option on "alter index".

Regards
Michel

Report message to a moderator

Previous Topic: Module in Statspack Report
Next Topic: TIMED_STATISTICS parameter
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jun 28 05:55:09 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.