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!

What if "index rebuild online" fails?

rahulrasMar 2 2012 — edited Mar 3 2012

Hi All,

Oracle v11.2 on Linux.

I am doing "alter index ... rebuild online" for a table of about 15million records.
For some reason, if the rebuild fails, will the index still be there? in usable state?
As I am doing the rebuild "online", I am expecting no harm to the index if the rebuild fails.
Please correct me if I am wrong.

Thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 31 2012

Added on Mar 2 2012

#general-database-discussions

3 comments

902 views