Re: Q: Sql*Loader maximum record length
From: Dave Brady <brady_at_fas.harvard.edu>
Date: 20 Jul 1998 12:57:22 GMT
Message-ID: <6overi$2c9$1_at_news.fas.harvard.edu>
Date: 20 Jul 1998 12:57:22 GMT
Message-ID: <6overi$2c9$1_at_news.fas.harvard.edu>
In article <6olhnl$fm_at_panix.com>,
WeeWillyKeeler_at_nowhere.com writes:
> I am trying to load data into a table using SQL*loader in 8.0.3, and am
> getting a "bad" file full of data. The "log" file say that the {whatever} is
> too big. Look:
I had the same problem. The problem is that SQL*Loader does not understand the VARCHAR2 datatype, and must be told what the size is:
Define REFERER in your control file with:
REFERER CHAR(500) (I wish the various groups at Oracle who write all their stuff would make them interoperate properly! Is that too much to ask?)
-- Dave Brady FAS Computer Services Sr UNIX Sys Admin/Programmer Harvard University brady_at_fas.harvard.edu LL1A Science Center Phone: (617) 495-1273 1 Oxford Street FAX: (617) 495-1210 Cambridge, MA 02138Received on Mon Jul 20 1998 - 14:57:22 CEST