05-01-08, 19:19 #1Registered User
- Join Date
- May 2008
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.
05-01-08, 19:59 #2Registered User
Provided Answers: 1
- Join Date
- Aug 2003
- Where the Surf Meets the Turf @Del Mar, CA
>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.
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.