I see that Howard and Richard have answered
the question. But if you want the full, gory details -
plus live demonstration etc. then UNDO is session 2
of my 3-day seminar. Booking for August in
Melbourne (AUS) - booking for Nov in Detroit
and Dallas.
--
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Next Seminars
UK Sept
Australia August
Malaysia September
USA x 2 November
http://www.jlcomp.demon.co.uk/seminar.html
Jeremy Russell wrote in message <3d39010b.50393862_at_usenet.plus.net>...
>OK, maybe it's too early in the morning, and maybe I'm just dumb, but
>what - in detail - is written to a rollback segment in Oracle 8i? I
>understand that a rollback segment records undo info for a transaction
>(used Oracle long enough for that level of comprehension at least!),
>but it was my understanding that the entire block would be written out
>for potential read consistency, recovery, rollback purposes.
>
>However, I have a feeling that may not be true.
>
>If I issue
>
> UPDATE emp SET ename='RUSSELL' where empno=7369;
>
>does the entire block where this employee resides get written, is it
>the entire row or is it just the changed column?
>
>If there's a link somewhere (technet or otherwise) that explains this,
>please let me have that, rather than taking up newsgroup bandwidth.
>
>TIA
>
>Jeremy Russell
Received on Sat Jul 20 2002 - 12:57:39 CDT
