-
SQL*Loader & usage of COMMIT
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.
Sankar B. Mandalika
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|