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 -> Re: Populating a database in Oracle 7.3

Re: Populating a database in Oracle 7.3

From: Joel Garry <joelga_at_pebble.ml.org>
Date: 1998/03/11
Message-ID: <6e77kq$sbh$1@pebble.ml.org>#1/1

In article <3506FEB4.3C86_at_ulst.ac.uk>,
Gareth Leonard <leonard-gg_at_ulst.ac.uk> wrote:
>How do I populate a database in oracle 7. I am using Oracle enterprise
>manager and do not understand how to get the data stored within my
>tables. Is therea simple way of doing this
>
>Gareth

There are a number of ways of doing this, depending on whether you already have data and in what form. The product SQL*Loader can handle a variety of formats from text files. You can use SQL*Plus and a bunch of insert statements like insert into yourtable values ('1','2','3');. You can use utilities like perl and frontends of various sorts. There is an embarrassment of riches. So, to get a decent answer, you must state what you have and what you want to do with it.

-- 
These opinions are my own and not necessarily those of Information Quest
jgarry@eiq.com                           http://www.informationquest.com
http://ourworld.compuserve.com/homepages/joel_garry
"See your DBA?"  I AM the @#%*& DBA!
Received on Wed Mar 11 1998 - 00:00:00 CST

Original text of this message

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