Re: SQL*Load file format question
Date: 1995/12/04
Message-ID: <dscott-0412952115490001_at_dscott.is.net>#1/1
In article <49m0ud$3of_at_bronto.minn.net>, mtharp_at_minn.net (Michael Tharp) wrote:
> John Moriarty <jmm_at_wang.com> wrote:
>
>
> > I am attempting to load a fixed format file
> >into an Oracle database using the SQL*Loader under HPUX.
> >The problem is the rows are not terminated by
> >carriage returns. It's a single file with one very
> >large physical line in it. SQL*Load doesn't know where
> >the end of the record is and subsequently reports that
> >row is greater than 64K and terminates.
> > Is there a way to specify the total length of the record?
> > thanks for any info,
> > John Moriarty
> > john.moriarty_at_wang.com
If I remember correctly (who knows, I'm at home), you can specify fix=nnnn
(where nnnn is your record length) in your OPTIONS string to arbitrarily
split the streamed record into fixed records.
HTH!
David Scott
...how can I keep from singing?
email: dscott_at_is.net
Received on Mon Dec 04 1995 - 00:00:00 CET