[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

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


Matt Warden
Cincinnati, OH, USA

This email proudly and graciously contributes to entropy.

More information about the thelist mailing list