Sunday, April 24, 2011

Upload/import DBASE/FoxPro DBF files into Oracle Database

If you need to import/upload data from DBF (DBASE or Foxpro database files), there is a script that already developed by Tom Kyte.

I have made some modification to fulfill my need, here are the changes:

  • Add UPLOAD_TIME column to keep date of upload process from DBF into oracle
  • Add support of MEMO fields that has more than 4000 characters

Howto use this script?

...

http://supriyatna.wordpress.com/2011/04/24/upload-dbasefoxpro-dbf-files-into-oracle-database/