import dbf files into oracle

Hope this can help:

https://www.experts-exchange.com/questions/20566597/Move-table-from-dbase-to-oracle.html

venko

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

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

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.

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

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.

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 Visual Loader at

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

d.r.b