Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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.
The rollback segment must store the values from every column that is
named in the update command. If a table has 10 columns and you refer to
5 of them in the update command but only 1 column gets a new value, the
rollback must record the before values of the 5 referenced columns.
Received on Wed Mar 11 1998 - 00:00:00 CST