Re: load big text file into long field

[Quoted] 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.com wrote in message news:<c9cd729c.0405241312.256e76cc_at_posting.google.com>...
> 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
Received on Tue May 25 2004 - 04:29:47 CEST