OraFAQ Forum: Server Utilities » SQL Loader Entire Job Commit

Home » RDBMS Server » Server Utilities » SQL Loader Entire Job Commit (Oracle 10g 2.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL Loader Entire Job Commit [message #307578]

Wed, 19 March 2008 03:36

@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.

Report message to a moderator

Re: SQL Loader Entire Job Commit [message #307589 is a reply to message #307578]

Wed, 19 March 2008 04:00

Littlefoot
Messages: 21809
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.

Report message to a moderator

Re: SQL Loader Entire Job Commit [message #307628 is a reply to message #307589]

Wed, 19 March 2008 05:37

@rpita
Messages: 7
Registered: February 2008
Location: Mumbai,India

Junior Member

Thanks...

Report message to a moderator

Previous Topic:	IMPORT/EXPORT ISSUES
Next Topic:	exp/imp error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 17 06:50:29 CDT 2024