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: 11
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

Report message to a moderator

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: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
See ROWS parameter, here.

Report message to a moderator

Previous Topic: IMP-00010
Next Topic: explain import and export database in oracle ?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 26 10:51:20 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.