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!

Taking care of indexes after Truncate !!

AnkitVJun 28 2012 — edited Jun 28 2012

Hello

I have 5 huge tables (20m rows each). Each has 2-3 indexes.
I need to truncate all 5 and then refill them.
I am concerned about indexes.
How to make sure that indexes have latest data only? They must have pointers to new data after re-fill and OLD data must not be present in them.

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 26 2012

Added on Jun 28 2012

#general-database-discussions

6 comments

847 views