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