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.
>

Maybe you should consider partitioning your table. If you just have local indexes on the table you can truncate a partition without affecting the rest of it.

Hope that helps,
Lothar

-- 
Lothar Armbrüster       | la_at_oktagramm.de
Hauptstr. 26            | la_at_heptagramm.de
D-65346 Eltville        | lothar.armbruester_at_t-online.de