Re: Q: SQL*LOADER and large varchar columns

From: Dave Brady <brady_at_fas.harvard.edu>
Date: 16 Dec 1998 19:54:25 GMT
Message-ID: <75935h$ps8$1@news.fas.harvard.edu>

Hi Bernd,

In article <3677F07C.E585D215_at_joice.net>,

Bernd Dormann <Bernd.Dormann_at_hamburg.netsurf.de> writes:
> I have some problems with SQL*Loader. I have to load some Ascii-files
> into an Oracle 8.0.4 database on NT. Some tables have columns
> varchar(1500). When I load data into these tables, the contents of these
> columns is truncated. Question: Is there a parameter for the SQL*Loader
> to insert 1500 bytes into a varchar(1500) column.

SQL*Loader does *not* understand all the Oracle datatypes (which is really dumb, wouldn't you say?)

You need to specify, in the control file, a VARCHAR(1500) datatype for those columns.

Dave Brady                 FAS Computer Services
Sr UNIX Sys Admin/DBA      Harvard University
brady_at_fas.harvard.edu      LL1A Science Center
Phone: (617) 495-1273      1 Oxford Street
FAX:   (617) 495-1210      Cambridge, MA 02138

Received on Wed Dec 16 1998 - 13:54:25 CST