Re: SQL*Load file format question

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

Check your ???.CTL file.

If it says FIXED, try changing it to STREAM.

Michael Tharp

St. Paul, Minnesota USA
mtharp_at_minn.net Received on Fri Dec 01 1995 - 00:00:00 CET