Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Size of rollback segments for a single transaction

Re: Size of rollback segments for a single transaction

From: John P. Higgins <jh33378nospam_at_deere.com>
Date: 1998/03/11
Message-ID: <35071406.5DC9@deere.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US