Home » RDBMS Server » Server Utilities » SQL Loader Entire Job Commit (Oracle 10g 2.0)
SQL Loader Entire Job Commit [message #307578] Wed, 19 March 2008 03:36 Go to next message
@rpita
Messages: 7
Registered: February 2008
Location: Mumbai,India
Junior Member
Hi,

Can we specify options such that SQL Loader can commit the entire job only at the end.
The only way I can think of is specifying higher values for the bindsize/readsize/rows parameters.

This is to tackle database going down/network going down in the middle of the load cases.
For this we would like to restart the load without having to manually sort out the records that were not loaded.
Re: SQL Loader Entire Job Commit [message #307589 is a reply to message #307578] Wed, 19 March 2008 04:00 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You can not (as far as I can tell). However, setting the ROWS parameter to a high value will reduce committing, but will also require large rollback segment (so, be careful - loading might be interrupted if you run out of space).

For more information, check the documentation.
Re: SQL Loader Entire Job Commit [message #307628 is a reply to message #307589] Wed, 19 March 2008 05:37 Go to previous message
@rpita
Messages: 7
Registered: February 2008
Location: Mumbai,India
Junior Member
Thanks...
Previous Topic: IMPORT/EXPORT ISSUES
Next Topic: exp/imp error
Goto Forum:
  


Current Time: Sun Dec 11 04:19:03 CST 2016

Total time taken to generate the page: 0.07041 seconds