We help IT Professionals succeed at work.

import dbf files into oracle

tomaz108
tomaz108 asked
on
I have some *.dbf files and i want import it into oracle database.
How to do it?
Comment
Watch Question

Author

Commented:
It takes too much time. I have 30 dbf tables.

Author

Commented:
It takes too much time. I have 30 dbf tables.

Commented:
Can you provide more info about what type of export was done?

I can guess that you have either schema or table level export.

Unfortunatelly, you will have to do 30 imports. Of course once you get the first 1 or 2 the rest should be pretty easy as there are very few things that need to change for every import.

I suggest you use a parameter file for the import. It makes it a lot easier. Let us know if you need the exact syntax.

Author

Commented:
I just want to copy data from dbf table into identical oracle table.

Commented:
Unfortunatelly you cannot just copy the data. Multiple steps are involved. You can try to create ODBC driver to access your dbf files and the connect to sql plus (OCI interface should be installed) and using the odbc connection copy the tables. But in all cases you will have to do 30 copies. Hey, this is not so many I would be finish and forget about this during the time between the first and last posting here.

Commented:


Have you tried  Heterogeneous services  in oracle . It is methode used to connect to other non oracle db's. Although i have not tried with dbase . I think it should work . It will allow u to access the dbase data through a dblink
Try dbf2Ora.exe;
www.kada.lt/alv/ora/dbf2ora/ 

Commented:
Try Visual Loader at

http://drbtools.netfirms.com.
It loads data into oracle from any odbc data source

d.r.b

Explore More ContentExplore courses, solutions, and other research materials related to this topic.