[thelist] fields larger than 4K in Oracle sql loader

Matt Warden mwarden at gmail.com
Fri Aug 14 08:26:55 CDT 2009


Gentlemen and Ladies:

I am using Oracle's sqlldr utility to load a flat file into a staging
table for further processing. I have a question that I cannot get
answered from The Google...

How do I select a character string longer than 4000? Can I concatenate
somehow using boundfillers? Do I need to use a special type (not
CHAR)?


<tip type="sqlldr">
If you are specifying a ROWS parameter and it seems to be ignored
based on the commit interval that results, try increasing the BINDSIZE
to 4054*ROWS (e.g. for ROWS=500, try BINDSIZE=2027000).

http://lbdwww.epfl.ch/f/teaching/courses/oracle9i/server.920/a96652/ch04.htm#1004690
</tip>

-- 
Matt Warden
Cincinnati, OH, USA
http://mattwarden.com


This email proudly and graciously contributes to entropy.



More information about the thelist mailing list