Re: Redo for the Undo

On 12/13/23 07:53, Lothar Flatz wrote:
> Hi,
>
> can a conventional delete produce redo for undo? And why? What I don't
> get: if the redo is applied, undo would be generated anyway, would it
> not?
>
> But maybe my idea of roll forward is a bit simplistic. Not really my
> area of expertise.
>
> Thanks
>
> Lothar
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
Hi Lothar,

Delete changes blocks, UNDO blocks among other things.  REDO mechanism protects the UNDO tablespace as well and generally writes any block change to the UNDO tablespace.

Regards

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

--
http://www.freelists.org/webpage/oracle-l