Bulk Delete

[dbasan]

thanks a lot guys for the link but I have already visited both the sites and nothing helpful have been found. I want a script to delete more than 1 millon rows........and a simple sql query will not do that........I mean it will hit my performance...........is there any pl/sql script doing commit after ever 1000 or 2000 rows and in this way my performance cannot be hit.

good you got the logic,

now delete those 1000 rows, use a date column in the where condition and then commit after delete. Do this as many times until you reach the required.

You can also script this as a batch file and run after business hours to complete before business start hour the next day.

good luck