Re: AW: Better Delete method
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sun, 11 Jul 2021 16:34:05 -0400
Message-ID: <29ba92d2-4cb7-7bcf-ea23-765ef6cb227d_at_gmail.com>
Date: Sun, 11 Jul 2021 16:34:05 -0400
Message-ID: <29ba92d2-4cb7-7bcf-ea23-765ef6cb227d_at_gmail.com>
Cloud! AI!
On 7/11/21 2:02 PM,
ahmed.fikri_at_t-online.de wrote:
with the current Oracle architecture this would only work for tables that fit into part of the buffer cache (the changes would only be made in memory and not written to the data files in case of rollback).
My solution that I use is based on partition exchange and works very well for me, but this could be implemented internally by Oracle itself. And that's what I mean by the willingness to implement new things.
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com-- http://www.freelists.org/webpage/oracle-l Received on Sun Jul 11 2021 - 22:34:05 CEST