Re: Loading a Ascii file

Peter -

[Quoted] It would have been nice if you'd mentioned your bias against SQL*Loader in your very first note in this thread. The various responders would not have wasted their time recommending SQL*Loader.

If you're out to reinvent the world, please proceed. If your goal instead is to load the data as quickly and efficiently as possible and get on with your "real" work, then you and your boss need to take a closer look at the already-existing tools. SQL*Loader is quite flexible, and it can handle [Quoted] comma separated fields from MS Excel with ease. Yes, you may have to create a number of SQL*Loader control files to handle the various input formats, but what's the alternative? IMO, you'll spend much, much, much more time and money developing your own "intuitive" interface than using what's already available.

Tom

Peter wrote:

> In general there is nothing wrong with sql*loader, but my boss is not very
> excited about this. The reason is that it is difficult to manage an xls file
> for example. It would be easier if there would be a direct interface. And
> also sql*loader is not very handy when the databases of origin differ to
> much (for example to import old data in a new remodeled database). I think
> you can save a lot of money if you can make a good utility that can do this
> in a more intuitive manner.
> "Thomas Gaines" <Thomas.Gaines_at_noaa.gov> schreef in bericht
> news:3D62C9DF.2EF01635_at_noaa.gov...
> > Whoa. Did you actually read the replies or what? In unison, we
> > answered "SQL*Loader". What's wrong with that fine Oracle utility?
> >
> > Tom
> >
> > Peter wrote:
> >
> > > First I want to thank you all for answering. Are there any programs that
> > > facilitate the uploading of datafiles???
> > >
> > > "Peter" <depend3_at_yahoo.com> schreef in bericht
> > > news:lw989.73546$8o4.9886_at_afrodite.telenet-ops.be...
> > > > 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?
> > > >
> > > >
> >
> >
> >
Received on Thu Aug 22 2002 - 18:33:45 CEST