Re: Data from legacy system

With the info you've given, sql*loader is your best tool. It was written exclusively to load ascii files (both fixed field and commadelimited)  into oracle. It can also combine multiple input lines into a single database record (as your example seems to indicate). You define the structure of your input file in a ctl file and then fire up sqlldr using that ctl file. It's documented in the Oracle Utilities manual.

In article <8tknq6$23j$1_at_nereid.worldonline.nl>,   "Toine Tuerlings" <su007675_at_wolmail.nl> wrote:
> You might want to write a PL/SQL package that picks up your data by
 the use
> of the UTL_FILE package.
> This standard Oracle package allows you to read operating system
 files.
>
> Toine.
>
> rdf <deficis_at_show.it> schreef in berichtnieuws
> 8tk0ee$39c$1_at_nslave3.tin.it...
> > hi,
> >
> > my contest:
> > I had a set of ascii files containing structured data, of this type:
> > field1field2field3field4
> > otherfield1otherfield2otherfield3
> > field1field2field3field4
> > otherfield1otherfield2
> > ...
> > and I should load them into oracle tables.
> >
> > and this is my simply question:
> > How to resolve this phase ?
> > Which is the best tool (access with odbc, VB, SQL*Loader) ?
> > How do you procede in thi contest ?
> > Many thanks.
> >
> > Renato.
> >
> >
>
>

--
Have a good day!
Roger Crowley DBA
MedImpact Healthcare Systems, Inc.
San Diego CA


Sent via Deja.com http://www.deja.com/
Before you buy.