Re: update

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 23 Oct 2001 16:11:29 +0100
Message-ID: <3bd588e1$0$8512$ed9e5944@reading.news.pipex.net>

The old value is held in the rollback segment associated with the transaction until the update is committed or rolled back.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"frank stueckler" <frank.stueckler_at_gillardon.de> wrote in message
news:3bd580b7$0$223$4d4ebb8e_at_businessnews.de.uu.net...


> Hi ORACLE-Freaks,

>

> can anybody tell me what happens inside an ORACLE Database (SQL Area,

> RedoLog, Rollback Segment) when I try to update a column with the same

value


> the column had before?

> Does ORACLE remember the old value although the update statement contains

> the same value?

>

> Thanks for help

> Frank

>

>

Received on Tue Oct 23 2001 - 10:11:29 CDT