Re: Using SQL*Loader to load a record sequential data file

check out the FIXED LENGTH (or something like that) option. You can tell SQL*LOADER exactly how long each record is. you don't need any newline stuff

In article <3315EB53.5DEC_at_mail.amsinc.com>, Rajiv Gidadhubli <G.R._Rajiv_at_mail.amsinc.com> wrote:

> Hi all,
>
> I need to load a fixed-length record sequential datafile(i.e, no new-line
> characters at end of record) using SQL*Loader into the Oracle database.
>
> I am not able to find any way to do this in the SQL*Loader documentation.
>
> I can change the file to Line sequential format(put a new-line character
> at the end of every record), but the size of the data file makes this
> approach prohibitive.
>
> I would appreciate if anyone could help me out with this problem.
>
> Thanks,
>
> Rajiv.
  Received on Fri Feb 28 1997 - 00:00:00 CET