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
What is the cause of the problem? Could you post the error message that you get? If not check the alert_log and let us know the error message just before the database had gone down.
Life is a journey, not a destination!
Give us the error message and we will be happy to help!!
Please post the alter.log file's messages, which helps to give solutions.
Click Here to Expand Forum to Full Width