Re: update Is Oracle update a direct update in-place?

From: Nuno Souto <nsouto_at_acay.com.au>
Date: 1997/01/07
Message-ID: <32D22E34.110D@acay.com.au>#1/1

Fengqing Zhou wrote:
>
> Hi!
>
> Sybase has direct update in-place and non-direct update in-place.
>
> Nondirect update in-place means a update is a DELETE followed by
> an INSERT.
>
> Direct update in-place means the record updated still keeps its original
> physical location after update.
>
> My understanding for Oracle update is:
> All updates in Oracle are "Sybase direct update in-place".
>
> Am I wrong?
>
> TIA,
You're correct. Rows in ORACLE can be relocated during an update if the block fills up, but it's still considered an update-in-place.

HTH
Cheers
Nuno Souto Received on Tue Jan 07 1997 - 00:00:00 CST