try to create huge rollback segment, let's say INITIAL 20M and NEXT 20M.

And force that transaction to be able to use that rollback segment by issuing the command below before the delete statement.

SET TRANSACTION USE ROLLBACK SEGMENT huge_rbs;
DELETE FROM temp_det......blah....blah. ...blah.