load big text file into long field

From: <vuht2000_at_yahoo.com>
Date: 24 May 2004 14:12:58 -0700
Message-ID: <c9cd729c.0405241312.256e76cc_at_posting.google.com>

Hi friends,
[Quoted] 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 Received on Mon May 24 2004 - 23:12:58 CEST