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: dbf --> Oracle Tables

Re: dbf --> Oracle Tables

From: John Koo <johnkoo_at_i-wave.net>
Date: Wed, 20 Jan 1999 13:47:49 +0000
Message-ID: <36A5DE84.E031D93@i-wave.net>


Rex wrote:

> Hi,
>
> I must load Oracle Tables from dbf files, and I have little program for
> that. I have approx. 250 files in dbf format and the same Oracle tables. For
> each table I must choose one dbf and one table which will load manualy. It
> is about 250 times again.
>
> Can I do it from Oracle Loader ( I suppose yes)?
> What is the control file for loader?
> Can anybody help me to do it.
>
> --
> Please remove nospam from my address to reply.
> nebacar_at_eunet.yu

You might :
transfer all dBASE *.dbf files to text format ( I'm sure this is a easy thing to do!) and
then load it into the Oracle using SQL loader,

or import the *.dbf files into Microsoft Access and then import into Oracle using the
Access Migration utility;

John K. Received on Wed Jan 20 1999 - 07:47:49 CST

Original text of this message

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