sqlloader commit problems
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: sqlloader commit problems

Hybrid View

  1. #1
    Join Date
    Nov 2002
    Location
    MADRID
    Posts
    8

    Question sqlloader commit problems

    Hi all,
    I've a problem executing sqlloader using ROWS.
    I need make this commit when finish all rows in te flat file (aprox. 11.000 rows, each), but always breakpoint each 56 rows.
    Any one could give me any idea?, I'm absolutly lost for.

    Thanks a lot to all......
    Angel

  2. #2
    Join Date
    Feb 2003
    Location
    France
    Posts
    2

    use readsize

    try with the option :
    readsize

    The READSIZE parameter lets you specify (in bytes) the size of the read buffer. The default value is 65536 bytes; however, you can specify a read buffer of any size depending on your system.

    In the conventional path method, the bind array is limited by the size of the read buffer. Therefore, the advantage of a larger read buffer is that more data can be read before a commit is required.

    For example:

    sqlldr scott/tiger control=ulcas1.ctl readsize=1000000

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