OraFAQ Forum: Server Utilities » Increasing commit record count in sql loader

Home » RDBMS Server » Server Utilities » Increasing commit record count in sql loader (Oracle 10g)

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

Increasing commit record count in sql loader [message #526459]

Tue, 11 October 2011 03:32

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

Report message to a moderator