| Bulk insert and commit [message #316998] |
Tue, 29 April 2008 01:53  |
muralikumarg
Messages: 33
Registered: August 2005
Location: Chennai
|
Member |
|
|
Hi,
I want to insert millions of records into the a table using FETCH BULK COLLECT AND FORALL..INSERT. I am planning to limit 10000 records in bulk fetch and bulk insert. Is it good to issue commit after each bulk insert of 10000 records?.
Rgds
Murali
|
|
|
|
| Re: Bulk insert and commit [message #317007 is a reply to message #316998] |
Tue, 29 April 2008 02:23  |
 |
Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
| Quote: | Is it good to issue commit after each bulk insert of 10000 records?.
|
No, the only good way is to do one and only one "insert select".
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
