Re: Deletion Of 160 Million Rows.

Hi ,

Thank You For The Respose...
Great Place To Get Some Troubleshooting Queries Solved.... Every One Doing And Great Job, And Thanx For Putting In Ur Precious Time. Have An Nice Day.
Sheldon

On Tue, 08 Feb 2005 16:16:07 +0000, ryan_gaffuri_at_comcast.net <ryan_gaffuri_at_comcast.net> wrote:
> 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.
>
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l