Reorganising huge tables
Hi,
We are in the process of implementing archiving process and archive huge amount of data from our OLTP system. There are few tables which have millions of rows and as part of the archive process we are going to delete few millions rows.
Question here is
what is the efficient way to reclaim the unused space from those segments where we ran bulk deletion. (In the past we have done Exp/Imp. This option is not possible since there is very minimal down time required from the business side)
I am not using Segement Space advisor since its part of Enterprise Edition feature.
We are in the process of implementing archiving process and archive huge amount of data from our OLTP system. There are few tables which have millions of rows and as part of the archive process we are going to delete few millions rows.
Question here is
what is the efficient way to reclaim the unused space from those segments where we ran bulk deletion. (In the past we have done Exp/Imp. This option is not possible since there is very minimal down time required from the business side)
I am not using Segement Space advisor since its part of Enterprise Edition feature.
0