Dear Friends...

I am one major problem while deleting rows from a table. I want to delete about 4,00,000 rows from a table. As soon as i delete rows from a table and commit the data, my database is become down.

I have to restart the database.

As it is my housekeeping job, and i have to run daily, and i don't want to down my database daily...


Please provide some solution on urgent basis.


Thanks in advance

Naresh