Originally posted by simply_dba
I ran the delete without the commit also :

Got the same error
Latest update is :
Set undo retention to 5000
commit every 5000 rows instead of 1000
Any solutions??
Am really in a fix with this
Load the data into a collection, then you can either do a bulk bind delete with only one commit or you can iterate through the collection and do as many commits as you like. Once you load the data into a collection there is no problem maintaining a read consistant view of the table which is what usually causes the ORA-1555 errors.