Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Text in sqlloader
I've run into this one before!
When defining your columns in your control file, iondicate a max length for
your long column, ex: col1 char(10000). When you run sqlloader it will
complain that your BINDSIZE is not large enough, and will tell you how many
bytes it should be. run it again with BINDSIZE=nn. I'm sure that there's
some way of calculating that size in advance, but it's faster to fail and
have Oracle calculate it for you!
--
+-----------------------------+-----------------------------+ | R. Steven Brown | Best Consulting | | rstevenbrown_at_earthlink.net | 1100 East 6600 South | | stevenb_at_bestnet.com | Suite 200 | | | Salt Lake City UT 84121 | | "When in danger, or in doubt| (801) 266-6138 - Office | | Run in Circles, Scream and | (801) 266-0069 - Fax | | Shout!" Lazarus Long | http://bestnet.com | +-----------------------------+-----------------------------+
Frank Heijmans <someone_at_somewhere.nl> wrote in message
news:37118e2d.64629956_at_news.xs4all.nl...
>Hi,
>
>I have a problem using the sqlloader. My datafile comes from a sybase
>SQLanywhere database. This database uses type 'long varchar'. This can
>store a maximum of 32K of text. The longest string in the datafile is
>940 chars. Now the problem. If I try to load this data in a table with
>a variable of type 'long' the rows with a length over 240 get
>rejected.
>
>Is should fit as far as I can see. So can anyone tell me what I am
>missing here.
>
>Regards
>
>Frank Heijmans
>F.Heijmans at nfs dot nl
Received on Mon Apr 12 1999 - 22:42:09 CDT