Re: load big text file into long field

Thank you so much for your advice, Romeo. It helps Tam
rolympia_at_hotmail.com (Romeo Olympia) wrote in message news:<42fc55dc.0405241829.4b941fca_at_posting.google.com>...
> 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 Thu May 27 2004 - 22:07:00 CEST