Home » SQL & PL/SQL » SQL & PL/SQL » Bulk insert and commit
Bulk insert and commit [message #316998] Tue, 29 April 2008 01:53 Go to next message
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 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Help
Next Topic: Select from Dual
Goto Forum:
  


Current Time: Sun Dec 04 22:52:49 CST 2016

Total time taken to generate the page: 0.09308 seconds