Re: Loading a Ascii file

From: Thomas Gaines <Thomas.Gaines_at_noaa.gov>
Date: Mon, 19 Aug 2002 12:32:00 -0600
Message-ID: <3D6139A0.416ECD8D_at_noaa.gov>


Peter -

[Quoted] SQL*Loader is part of the standard Oracle installation. You should find it wherever the executable Oracle programs for your OS are stored. Look for a file
[Quoted] called sqlldr.exe on either your Unix or Win2000 machine.

Tom

Peter wrote:

> Ok , I knew that this exists, but can you download it somewhere? Or is it
> somewhere in another program?
> "Daniel Morgan" <dmorgan_at_exesolutions.com> schreef in bericht
> news:3D612AA0.B456E2E5_at_exesolutions.com...
> > Peter wrote:
> >
> > > Hay, I'm having a small problem. I have an Asciifile with only text and
> > > columns are 'seperated' by distance. In this case I have some columns
> that
> > > are attached for a few records. So I started with placing the columns
> > > manually in Excell. Is there a simple way to load an csv or even xls
> file in
> > > an oracle database. I have sqlplus and toad available, what is not much.
> > > Does anyone have a fast way to load this?
> >
> > SQL*Loader
> >
> > For information on this tool go to http://tahiti.oracle.com and search for
> "SQL
> > Loader".
> >
> > Daniel Morgan
> >
Received on Mon Aug 19 2002 - 20:32:00 CEST

Original text of this message