Home » RDBMS Server » Server Utilities » Increasing commit record count in sql loader (Oracle 10g)
Increasing commit record count in sql loader [message #526459] Tue, 11 October 2011 03:32 Go to next message
mani_rbs
Messages: 8
Registered: January 2011
Location: Chennai
Junior Member
Hi,

I have created a sql loader control file to load a delimeter file in a table.

The file gets loaded into the table properly, however the commit is happening for every 64 records.

My aim is to rise the commit count by 1000 records. Can I please know how to do it?

Thanks & Regards,
Mani
Re: Increasing commit record count in sql loader [message #526462 is a reply to message #526459] Tue, 11 October 2011 03:39 Go to previous message
Littlefoot
Messages: 18826
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
See ROWS parameter, here.
Previous Topic: IMP-00010
Next Topic: explain import and export database in oracle ?
Goto Forum:
  


Current Time: Fri Apr 18 09:39:49 CDT 2014

Total time taken to generate the page: 0.10026 seconds