load big text file into long field - 05-24-2004 , 04:12 PM
I have a text file of size 30M, single-line and want to load it to a
table in my oracle (9i) database. The table has only 1 column of type
long. However sqlldr always returns this error:
SQL*Loader-510: Physical record in data file is longer than the
Here's the control file:
unrecoverable LOAD DATA
INTO TABLE chr_sequences
FIELDS TERMINATED BY "\t" OPTIONALLY ENCLOSED BY '"'
I also played something with the control file (like readsize,
bindsize) but couldn't get it work.
Can anybody help me?
Re: load big text file into long field - 05-24-2004 , 09:29 PM
(1) You're trying to load a large object (30MB). See the Oracle
Utilities / Sqlloader documentation for info on loading LOBs.
(2) Do consider using CLOB datatype instead of LONG. This will save
you from numerous headaches in the future.
vuht2000 (AT) yahoo (DOT) com wrote in message news:<c9cd729c.0405241312.256e76cc (AT) posting (DOT) google.com>...
Re: load big text file into long field - 05-27-2004 , 03:07 PM
Thank you so much for your advice, Romeo. It helps
rolympia (AT) hotmail (DOT) com (Romeo Olympia) wrote in message news:<42fc55dc.0405241829.4b941fca (AT) posting (DOT) google.com>...