Re: Redo for the Undo
- From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 13 Dec 2023 09:34:49 -0500
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
--
//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
Other related posts: