Re: Copying dBase to Oracle

From: <bonanos_at_yahoo.com>
Date: Wed, 03 Jun 1998 06:23:42 GMT
Message-ID: <6l2q5d$75o$1@nnrp1.dejanews.com>

> I want to convert a database from dBase to Oracle (7.3).
> What is the best methode to perform this conversion?

There are a couple of ways to do this:

You can import the dBase file into MS Access and export as a delimited text file.Then create the table in Oracle and import it using sqlldr73. sqlldr is oracles text loading utitility. You will find examples (.ctl) in <oracleroot>\rdbms73\loader\
You can import the file into access. Create the table in Oracle, Link the table in access via ODBC and then copy from dbase data to Oracle inked table.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Jun 03 1998 - 01:23:42 CDT