Mass/Bulk Delete assistance needed...
Hello, all. I'm trying to do a mass delete in 10g on a table with 2M records. I need to delete 530K records. I wrote a simple "Delete from table where field=value to be deleted" query two days, and its still running. When I do a Select count(*) for these records, they are still in the table. They have not been deleted after 2 days. Any pointers would be appreciated. Can someone suggest a way of doing this in chunk, say a Commit after every 5K records, etc.
Thanks,
Roz
0