Re: oracle sql*loader with a long field
Date: 1997/10/21
Message-ID: <344d09a4.24224803_at_newshost>#1/1
sqlldr defaults char fields to char(255). You can override that default setting by issuing something like:
OAD DATA
INFILE *
REPLACE
INTO TABLE TEST
( really_long_data char(100000)
)
In your control file (that would allow for upto 100,000 bytes to be loaded using that field). You also need to pay attention to the bindsize sqlldr parameter when loading large fields. For example, If I don't set the bindsize parameter on the command line and use the above .ctl file, I'll get:
SQL*Loader-600: Specified max. bind size 65536 bytes must be 100004 bytes to hold 1 row.
In order to get around that I'll use:
$ sqlldr ..... bindsize=100004
On Mon, 20 Oct 1997 16:38:36 -0600, mani.allu_at_mci.com wrote:
>Hi Guys!
>
>I am trying to load a 'long field from a .dat file using sql*loader.
>Some of the records are getting rejected due to error
>"Field in data file exceeded maximum specified length".
>
>When I specify the field in the control file as CHAR, I am not getting
>any errors but no data is getting loaded.
>
>can anybody help me in this!
>
>thanks in advance
>
>Mani
>
>-------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD
http://govt.us.oracle.com/ -- downloadable utilities
Opinions are mine and do not necessarily reflect those of Oracle Corporation
NOTICE: In order to cut down on the amount of time I spend applying silly logic to email addresses like "In order to cut down on spam, remove THIS from my email" or "In order to cut down on spam, reverse my email address", etc, I will simply hit delete when that mail bounces back to me, which is what I do with spam myself.
I haven't figured out whats more time consuming for me, deleting spam or resending emails after re-reading the whole thing to figure out the algorithm to apply. Received on Tue Oct 21 1997 - 00:00:00 CEST