Skip to Main Content

SQL & PL/SQL

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!

schedule the index rebuild online

RamanMar 14 2011 — edited Mar 14 2011
hi,

i need to schedule a job at database level to rebuild the indexes online every month. any script exist? like procedure to be invoked on every month to rebuild indexes for identified 5 tables in our project?

it is in production

we are running in oracle 10g in solaris platform.
This post has been answered by Mahir M. Quluzade on Mar 14 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 11 2011
Added on Mar 14 2011
5 comments
414 views