Hi,

Theres a parameter called as rows in sqlloader.

Dont know what the default value is, but u can check it out.

Assuming there r 4 records

if u say sqlloader s/s@abc control=a.ctl rows=1

Commit point reached - logical record count 1
Commit point reached - logical record count 2
Commit point reached - logical record count 3
Commit point reached - logical record count 4

if u run now like this

sqlloader s/s@abc control=a.ctl rows=2

Commit point reached - logical record count 2
Commit point reached - logical record count 4

So if u specify the attribute it will insert all the records and then do a commit.

I dont think you totally switch commit off....

Hope i understood ur question right...

Srini