On Tue, 01 Feb 2005 18:20:21 +0800, Hemant K Chitale
<hkchital_at_singnet.com.sg> wrote:
>
> True. The Temporary Segment has already been created. Next Extents are being
> allocated. That is why SEG$ is being updated. My question was about
> why the update to SEG$ has to re-update *EVERY* column in the table.
oops, I didn't really contribute anything there. sorry. If its any
consolation I'd probably write the code the same way - i.e. not bother
to check what has changed and what hasn't - after all as we all know
space management operations are a very rare operation in databases. If
it was written the way the apps I manage are written it would be a
delete and an insert for every column for each row :)
--
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Feb 01 2005 - 11:25:37 CST
