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




Oracle LazyDBA home page