Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: SQL Loader Question

Re: SQL Loader Question

From: <benlag_at_aent.com>
Date: Mon, 18 Sep 2000 19:24:02 GMT
Message-ID: <8q5q3o$61i$1@nnrp1.deja.com>

Unfortunately this process will not be done manually. An ftp script will pick up the file and load it automatically.

Thanks for your help,

Benny

In article <8pt93q$nru$1_at_nnrp1.deja.com>,   alistair.thomson_at_sphinxcst.co.uk wrote:
> 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.
>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US