How to delete rows in chunks?
672680Jul 20 2009 — edited Jul 21 2009How to delete 12,33,200 rows in oracle table ?
I want to delete 10000 rows each time, otherwise, my rollback segment is not large enough to handle it.
So, is there any way or any easy way to do it?
Is there anyway to do this in one sql statement? I assume no. Correct me if I am wrong:-)
Thanks in advance!
Edited by: PhoenixBai on Jul 21, 2009 10:39 AM