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!

best way to rebuild all the indexes in a schema

576856May 13 2009 — edited May 13 2009
Hi,

DB : 9.2.0.7 (TEST Instance)
OS : HP-UX Itanium 11.23

we have TEST schema which contains 1960 Tables and 1800 Indexes.

we have requirement to rebuild all those indexes.

what is the best way to do this task?

Note: This TEST schema was created and imported with PROD schema of Production ( Schema wise import)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 10 2009
Added on May 13 2009
#general-database-discussions
4 comments
4,682 views