|
-
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
|