Results 1 to 2 of 2
  1. #1
    Join Date
    May 2008
    Posts
    1

    Unanswered: Incremental Commit on Large Insert

    Hello everyone, hope you can help me with this. My team and I are trying to insert about 150 million records from a query using 4 tables into 1 table. Due to hardware limitations, we need to commit ever n number of records. The best solution we have found so far is a loop that has an iteration counter, and commits when the counter is divisible by a certain number. However, that involves inserting rows 1 at a time, and slows down the insert dramatically. A technical expert has recommended using arrays to insert records in bulk, but we cannot find any information on that. Any help would be greatly appreciated. Thanks.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >A technical expert has recommended using arrays to insert records in bulk, but we cannot find any information on that.

    Sorry to hear that GOOGLE is broken for you.
    Please continue to hold; while the Internet gets repaired for you.
    If you get bored while waiting to be spoon fed answers,
    you could try using the free clues contained in the STICKY post at the top of this forum which you conveniently ignored.

    http://www.dbforums.com/showthread.php?t=1031644

    Results 1 - 10 of about 70,900 for oracle bulk insert

    Do NOT be surprised if/when you do intervening COMMITS, that you start getting ORA-01555 errors.
    Last edited by anacedent; 05-01-08 at 20:04.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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