SQL*Loader & usage of COMMIT
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: SQL*Loader & usage of COMMIT

  1. #1
    Join Date
    Nov 2003
    Posts
    31

    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

  2. #2
    Join Date
    Jan 2003
    Location
    Hull, UK
    Posts
    220
    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
  •  


Click Here to Expand Forum to Full Width