sqlloader commit problems
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......
try with the option :
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.
sqlldr scott/tiger control=ulcas1.ctl readsize=1000000
Click Here to Expand Forum to Full Width