Re: No logging during delete

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Sun, 20 Nov 2005 02:16:47 +0100
Message-ID: <437fce80$0$6678$ba620e4c@news.skynet.be>

<prasath.rao_at_gmail.com> wrote in message news:1132161022.634589.167020_at_g49g2000cwa.googlegroups.com...
> Hi,
>
> I am interested in knowing how to delete millions of records
> periodically from a table efficiently.
>
> Can we use the nologging option on the table?
>
> I am NOT looking for solutions which copy the records across a
> temporary table, truncating the original table, renaming etc.
>
> Thanks,
> Prasath.
>

Btw have you tried a parallel delete operation ?

alter table <...> parallel;
alter session enable parallel dml;
delete /*+ parallel */ from <...>;

Matthias Received on Sat Nov 19 2005 - 19:16:47 CST