Re: Dbase DBF files port to Oracle

From: Brent Tucker <bxtucke_at_sp5-18>
Date: 1995/12/08
Message-ID: <4a9rpb$o6e_at_cpcnews.cp.nts.uswest.com>#1/1


Cheryl Cesario x-2866 writes:

> I have DBF files from DBASE that need to be ported into an Oracle database
> on a SGI. Can Oracle do this or do I need to write a filter?
>
> Thanks in advance.
> Cheryl
> -
> ==========================================================================
> Cheryl C. Cesario Cheryl.Cesario_at_rams.ssc.nasa.gov
> Computer Analyst/Senior Voice: (601) 688-2866
> Scientific Systems Section Fax: (601) 688-7918
> Lockheed Martin Stennis Space Center
> http://www.lmco.com http://www.ssc.nasa.gov/
> ==========================================================================

Cheryl,

I haven't tried what your looking for in DBase, but with ODBC it is easy.

Import your DBase .DBF files into any ODBC compliant MS Windows based database (Access for instance). The set up the ODBC connection for Oracle, open your Windows database, and use the export function through ODBC. I have done this several times with Access, and also with Paradox for Windows.

You will end up with a database mirroring your PC based database, which may not be exactly what you want, but it can be a good start. The table create statments take place automatically. I had to massage the tables once they were on the Oracle database to change storage parameters, etc.

One note: Make sure that your ODBC connection into Oracle uses the userid of the schema owner that you want to own the new tables.

Good Luck!

Brent

bxtucke_at_cp.mnet.uswest.com Received on Fri Dec 08 1995 - 00:00:00 CET

Original text of this message