Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: No logging during delete

Re: No logging during delete

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Sun, 20 Nov 2005 02:10:54 +0100
Message-ID: <437fcd1f$0$6821$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.
>

To speed up the deletes, it might help to disable or drop all indexes, triggers, constraints, ... prior to the operation.

Matthias Received on Sat Nov 19 2005 - 19:10:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US