RE: Deletion Of 160 Million Rows.
- From: ryan_gaffuri@xxxxxxxxxxx
- To: wbfergus@xxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Tue, 08 Feb 2005 16:16:07 +0000
create table as nologging is the tried and true best way to do handle this. i
believe its tom kytes recommended way of handling this also on asktom.
-------------- Original message --------------
> This depends on your application, but another way might be as follows:
>
> 1. Copy your table to another area.
> 2. Truncate your original table (truncate is much faster without the =
> undo
> problem).
> 3. Insert into the original table from the copy for the records you want
> to keep.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
