-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|