I'd take a good look at the possibility of using export/import for that.
IIRC 10g's data pump allows you to use "where" clause when importing
tables.

So I'd export the table, drop it and import it back using the "where"
clause to import just the data you need.

I think that's the fastest way to do this.

-----Original Message-----
From: Tavousi Mahnaz
[mailto:oracledba-ezmlmshield-x14873074.[Email address protected]
Sent: Wednesday, May 10, 2006 4:58 PM
To: LazyDBA Discussion
Subject: In ORACLE 10 how can I delete 100 million rows ?


Hello,

I want to delete more than 100 million rows from a huge table. I know it
is a time consuming process. I have created a new table and I want to
copy the rows that I want to keep (more than 600 millions) into the new
table.
Then I have to create indexes for that new table (which it is a time
consuming process again).
I am wandering if there is some other way to get it don't more quickly.

Thanks





--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________

Oracle LazyDBA home page