Database down while deleting ...
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Database down while deleting ...

  1. #1
    Join Date
    Oct 2000
    Posts
    6

    Angry

    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


  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Feb 2001
    Location
    Adelaide, Australia
    Posts
    159
    Yes,

    Give us the error message and we will be happy to help!!

    Kind regards,

  4. #4
    Join Date
    Feb 2001
    Posts
    15
    Hi,
    Please post the alter.log file's messages, which helps to give solutions.

    Regards,
    yajman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width