Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> data import?

data import?

From: Olaf Eilers <o.eilers_at_t-online.de>
Date: Thu, 20 Feb 2003 02:23:02 +0100
Message-ID: <b31akg$kc2$07$1@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 - 19:23:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US