Re: Data from legacy system
Date: Mon, 30 Oct 2000 22:11:47 +0100
Message-ID: <8tknq6$23j$1_at_nereid.worldonline.nl>
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.
>
>
Received on Mon Oct 30 2000 - 22:11:47 CET