Problem updating Table with 90 million records
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Problem updating Table with 90 million records

  1. #1
    Join Date
    Sep 2006
    Posts
    2

    Problem updating Table with 90 million records

    Hi All,

    I have a table that has 90 million records and all I want to do is a simple update, add a flag to each record based on the criteria of the update statement but it keeps on crashing on me. I can't believe that Oracle 8i can't handle 90 million records so there must be something else going on. Can anyone tell me what I am doing wrong or whether there is something happening in the background that is causing the update statement to crash?

    Thanks,
    Edward

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    and the error is ............

  3. #3
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,027
    Try using pl/sql collections with bulk collect and forall. You may want to break up the update statements into chunks based on the criteria.
    this space intentionally left blank

  4. #4
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Post the statement and the table structure (and the error, as Davey says)
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

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