Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: data import?
sql*loader
See Oracle utilities manual fro syntax
Anurag
"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?
>
> thanks,
> Olaf
>
> --
> Live as if you were to die tomorrow.
> Learn as if you were to live forever.
> - Gandhi
>
Received on Wed Feb 19 2003 - 20:24:34 CST