Home » RDBMS Server » Server Utilities » dBase to Oracle8
dBase to Oracle8 [message #368383] Mon, 11 December 2000 11:41 Go to next message
Salil
Messages: 2
Registered: December 2000
Junior Member
Hi,

Can anyone please advise on how to migrate data from dBase to Oracle8

Thanx

Salil
Re: dBase to Oracle8 [message #368388 is a reply to message #368383] Tue, 12 December 2000 09:20 Go to previous message
Bala
Messages: 205
Registered: November 1999
Senior Member
Hi Salil

Is this data migration should happen only once, or more than once...
If it is going to be only once you can...
download the dbase data in text format and manually create tables in oracle and load the text data using sqlloder utility....
For exporting data into text file you can use odbc, or even you can use MS-Access to connect to your dbase tables and export them to text files...

If you want to do it on regular basis then you can use third party tools such as Datajunction which has an engine using which you can automate the migration.

or go to this link you can find a plsql package to read the dbase files and write to oracle tables....
http://osi.oracle.com/wa/ask/owa/ask_tom_pkg.display?p_dispid=711825134415&p_search_str=%7BDBASE%7D
Previous Topic: max filesize for sql loader
Next Topic: REUSE option with CREATE TABLESPACE...
Goto Forum:
  


Current Time: Wed Dec 08 22:51:31 CST 2021