Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Rebuilding Indexes

John-MKFeb 13 2012 — edited Feb 13 2012
Hi,

I had a request initially to REBUILD INDEXES ONLINE, but I figured out that this feature is not available with STANDARD EDITION DB. DB is 10.2.0.4, OS Linux RH. I have read that I have the option to rebuild indexes OFFLINE, like

"ALTER INDEX index_name REBUILD tablespace tablespace_name"

Do I have to take care of something before applying the above command in the production database? Is it better to rebuild indexes while giving different tablespace name or the old one is just fine? In short, Please suggest any drawbacks of applying above command (if any).

Thanks a lot.

Regards
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 12 2012
Added on Feb 13 2012
#general-database-discussions
10 comments
590 views