Re: AW: Better Delete method
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sun, 11 Jul 2021 16:15:24 -0400
Message-ID: <a7e45e93-b70b-85b8-9af4-04366e6526a5_at_gmail.com>
Date: Sun, 11 Jul 2021 16:15:24 -0400
Message-ID: <a7e45e93-b70b-85b8-9af4-04366e6526a5_at_gmail.com>
Well, when I suggested "Wally solutions", I didn't expect someone to come up with one so quickly.
On 7/11/21 1:07 PM, ahmed.fikri_at_t-online.de wrote:
> The problem is that Oracle is not ready to change concepts from the
> 1970s.So why not introduce (implement) a note /*+
> dml_no_consistency_read * /, for example. If this hint is used in a
> delete statement, nothing is written to the UNDO and if the user has
> chosen to roll back, appropriate redos are identified and skipped.
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com -- http://www.freelists.org/webpage/oracle-lReceived on Sun Jul 11 2021 - 22:15:24 CEST