Hi friends,
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
maximum(1048576)

Here's the control file:

unrecoverable LOAD DATA
INFILE '/home/oracle/chr1_sequence.txt'
INTO TABLE chr_sequences
FIELDS TERMINATED BY "\t" OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(chr_sequence)

I also played something with the control file (like readsize,
bindsize) but couldn't get it work.
Can anybody help me?
thanks,
Tam

2 Things:

(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.

Cheers,

Romeo

vuht2000 (AT) yahoo (DOT) com wrote in message news:<c9cd729c.0405241312.256e76cc (AT) posting (DOT) google.com>...

Thank you so much for your advice, Romeo. It helps
Tam
rolympia (AT) hotmail (DOT) com (Romeo Olympia) wrote in message news:<42fc55dc.0405241829.4b941fca (AT) posting (DOT) google.com>...