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!

Index Rebuild with Nologging - Pros & cons

Sarat_yahooJul 19 2017 — edited Jul 23 2017

Hi Gurus -

Version - 11.2.0.4

Every year we have maintenance jobs (purge,index rebuild etc.,) in our production database - so as a part we are doing rebuild all the indexes in prod databases using online.

So I want to use NOLOGGING option when doing index rebuild.

Like - Alter ..index rebuild online nologging (once index rebuild) i will change the index to logging. Here I want to know what are pro's & con's of using this method.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 20 2017

Added on Jul 19 2017

#general-database-discussions

24 comments

6,053 views