Re: Size of rollback segments for a single transaction

Olivier wrote:

> I am updating every row of a single column in a table containing many rows
> and many columns. What is the minimal size of the rollback segment for that
> transaction ? Will the rollback segment have to store all data contained in
> the table or just the values actually changed by the transaction?
>
> Thanks Olivier.

All data stored on table. Rollbacks store db blocks, not rows. Also, if that column happens to be part of an index, you also need space for the index blocks that get changed. If this is a problem, try to do it in portions, ie, first n-thousand rows, commit, next n-thousand rows, etc. Re-open the cursor after every commit or the data will still be in the rollback segment.

HTH
Cheers
Nuno Souto
nsouto_at_acay.com.au Received on Sun Mar 15 1998 - 00:00:00 CST