| dBase to Oracle8 [message #368383] |
Mon, 11 December 2000 11:41  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
