SQL*Loader & usage of COMMIT

[sankar6254]

Hi,

I am reading from a .csv file and uploading an Oracle table via SQL*Loader. The input is a flat file (.csv). I would like to know if COMMIT comes into play at all when doing an upload via SQL*Loader? In other words, is there any way I can set the commit to off till my table is uploaded? Any hints would be greatly appreciated.

Thanks,
Sankar.

[Srinivas_Sharma]

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