Re: how to delete parts of data of a very large table quickly?

the best way may be to create a temporary table and insert the rows you want saved from this table into the temporary table. Then truncate the original table, and reinsert the rows from the temporary table. The 'truncate' command will bypass any redo activity and will be much faster than a normal delete. Also keep in mind that there's no rollback from a truncate, so if you execute this command, make sure that this is what you want.

zhangguoping_at_boco.com.cn wrote:

> i have a very large table, i want to delete some data. The data to be
> deleted is also very large. i am afraid rollback segment may suffer from it.

--
Phillip