Re: No logging during delete

prasath.rao_at_gmail.com wrote:
> 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.
>

I believe the same question was answered by Tom Kyte: http://asktom.oracle.com/pls/ask/f?p=4950:8:16775427798794822224::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:5033906925164 about 3 years ago.

Wrap up: don't delete, use CTAS.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...