Re: Transactions requires much more UNDO space than expected....

> 3 If you populate an empty index you force Oracle to rebalance the
> B*-tree often. If you create the index after the table has been
> populated, the index will be balanced right away. Always create indexes
> in a separate pass after importing data. One other advantage is this
> can be a nologging operation.
>

Does 'alter table move..' require the same amount of UNDO..?

If not, it may be better/quicker to do a MOVE and then rebuild the indexes, instead of copying all the data out and back in again.

Matt Received on Mon Jun 19 2006 - 07:42:59 CDT