-
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
-
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.
Sam
-
Yes,
Give us the error message and we will be happy to help!!
Kind regards,
-
Hi,
Please post the alter.log file's messages, which helps to give solutions.
Regards,
yajman
