Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Incremental Commit on Large Insert
I appreciate the suggestions. We considered a solution where we insert using rownum as a limiter in the selection criteria, but our big concern is the time involved in querying each time. A select * from <table> on that table takes a little while, like 20-30 seconds, due to its sheer size, so...- phobia42
- Post #6
- Forum: Oracle: All versions
-
Incremental Commit on Large Insert
Hey guys, 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...- phobia42
- Thread
- Replies: 9
- Forum: Oracle: All versions
