Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: SQL Loader Question
Just a thought.
Can you open this file in a spreadsheet and save it as a CSV file, it would be much easier to handle.
alistair.thomson_at_sphinxcst.co.uk
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.
Received on Fri Sep 15 2000 - 08:44:32 CDT