Re: SQL Loader Question

Tried this. Because the file is so huge and it is not using standard Unix line termination the script fails. I think the sed command has a limitation of how large 1 input line can be. It gives me a data flow error that is similiar to the error I receive when trying to use vi (line too long error).

The file can also be downloaded using DBF file format but am not sure if Sql*Loader(on Unix) will support that format. If I can get help on doing this it would greatly appreciated.

Thanks a lot for your help,

In article <8pu362$oc6$1_at_nnrp1.deja.com>,   Alex Filonov <afilonov_at_pro-ns.net> wrote:
> Can't you filter this file through sed, changing char(002) into
> linefeed? You can load result file without any problems.
>
> In article <8pqsdt$8p$1_at_nnrp1.deja.com>,
> benlag_at_aent.com wrote:
> > I am currently using Oracle version 8.0521 on a HP-UX11 system and
 have
> > a SQL*Loader question.
> >
> > I am trying to load a sequential file that contains 3 columns with
 the
> > column delimiter being a ASCII char(001) and the line delimiter
 being
 a
> > ASCII char(002). I cannot change the structure of the file (I have
 to
> > load using these delimiters). The field delimiter is not a problem
 but
> > I am having problems telling SQL*Loader which character is the line
> > delimiter. How can I tell SQL*loader how to load this file??
> >
> > The following is record from the actual file:
> > D 64 Artistic Style B Surrealism
> >
> > Any help or suggestions would be greatly appreciated,
> >
> > Benny Lago
> > Alliance Entertainment, Inc.
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Sep 18 2000 - 14:36:42 CDT