Re: sqlldr lines too long?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Tue, 12 Oct 1999 08:49:35 -0400
Message-ID: <Bi4DOHSQLW+QOzR3MTLA2S1zVSUi@4ax.com>

A copy of this was sent to Allan Tingey <al_at_genetics.utah.edu> (if that email address didn't require changing) On Mon, 11 Oct 1999 15:38:40 -0600, you wrote:

>Oracle 8
>Tru64 UNIX
>
>sqlldr seems to be unhappy with more than 256 characters per line
>of data. Is there any way around this?
>
>thanks,
>
>Al Tingey
>al_at_genetics.utah.edu

sqlldr by default limits character strings to 255 bytes.

If you have a control file like:

LOAD DATA
INFILE test.dat
INTO TABLE T
(data)

and your max line size is 1000 bytes, do this:

LOAD DATA
INFILE test.dat
INTO TABLE T
(data char(1000) )

use char(maxsize) to override the default of 255.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Oct 12 1999 - 07:49:35 CDT