Re: data import?

"Olaf Eilers" <o.eilers_at_t-online.de> wrote in message news:b31akg$kc2$07$1_at_news.t-online.com...
> hi gurus,
>
> i have a simple question, but i never have used oracle before:
>
> i got some hundred of MBytes data in ascii-files (every single line a
> dataset, like name street zip ...) to import into our soon to come oracle
> db. so how i thought to handle it was like this:
>
> writing a simple programm to convert ascii-files into sql-statements
> calling oracle like:
> oracle --login username --password mypassword database < statements.sql
> is this possible? how?
> another (better) way to import ascii-files into oracle db?

If your ASCII files are a consistent format, SQL*Loader is the easiest way to do it. If they are a bit more complex, you can use the UTL_FILE package from PL/SQL to read the files directly. Received on Thu Feb 20 2003 - 04:36:23 CST