Oracle Database Discussions

Hi,


I have a situation in such a way that we truncate few tables and then we loaded the data [only content] on to those tables. Thus requiring rebuilding the indexes online is required or not???


And one more question is If we drop few indexes does the total amount of space gets released or not. And recreating those indexes will use the same amount of space. As i don't have the more disk space???? In this situation rebuilding the index online will be a better idea...

Can you please suggest on this...


truncating the few table + loading the few tables + rebuilding the indexs online is better (or) droping the few tables + loading the few tables + recreating the indexes is better

Can you suggest the better path... We have a sistuation that the presently we doesn't have more enough space on the disk.. [The option should n't effect the space]