[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