best way to delete large number of rows

[virajvk]

delete from table1 where x=y nologging;

I dont think this will work.
Good idea is already suggested by stmontgo

I use PL/SQL loop commiting after every 5000 rows

Regards

---------------------------
9i OCP
First post After Becoming Oracle Certified