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

On 19 Jun 2006 05:42:59 -0700, mccmx_at_hotmail.com wrote:

>> 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..?

That I don't know, as I have never felt the need to measure undo during alter table move
(measuring undo is pretty easy as you only need to

set autotrace on explain stat

prior to the first statement you want to measure.

>
>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

--
Sybrand Bakker, Senior Oracle DBA