Estimate log space reorg index will use
We need to reorg the index of a table in order to enable Large RIDS. The index size is approaching the 16K tablespace limit, however using DB6CONV to move this table and indexes will take about 10-12 hours and we cannot afford this much downtime.
I would like to try a reorg indexes all on this table, however am concerned about the amount of log space this will use and would like to try to estimate this. Is there any way to do this? Also, is there any way to estimate how long an index reorg will take?