| Bulk insert and commit [message #316991] |
Tue, 29 April 2008 01:43  |
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 #316997 is a reply to message #316991 ] |
Tue, 29 April 2008 01:50  |
Michel Cadot
Messages: 15238
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
This is NOT an expert question.
It is clearly stated in the forum description: "Newbies should not post to this forum!"
Expert notion is defined in the sticky: Not an EXPERT? Post in the NEWBIES forum, NOT here
Rules are described in: OraFAQ Forum Guide
Read them, follow them including what is said about formatting.
As you are an expert, I don't answer the question because you obviously already knows it.
Why not insert select?
Regards
Michel
|
|
|
| Re: Bulk insert and commit [message #317219 is a reply to message #316997 ] |
Wed, 30 April 2008 01:16 |
rleishman
Messages: 2563
Registered: October 2005
Location: Melbourne, Australia |
Senior Member |
|
|
Take a look here.
And do a search on ORA-01555 to find out why interim commits are generally a bad idea. For your particular case though, I doubt it would be a problem.
Also, if you are determined to use an iterative approach, I would consider reducing your array size to 1000 or thereabouts. You won't notice the overhead of the smaller array, and it protects you from overfilling memory.
Ross Leishman
|
|
|
]
Members
Search
Help
Register
Login
Home
