Migrating from FoxPro to Oracle

I would like to extract long or clob data to flat file (text file). Is there any dbms_package or procedure available

for this issue? I would also like to migrate FoxPro table with contains memo field to Oracle table. Is there any way to do a migration from FoxPro to Oracle? For extracting the data to a flat file, why not just use SQL*Plus? SQL*Plus can read the contents of a LONG or CLOB column. Use the SPOOL command in SQL*Plus to place the output from your query into a file. There is a DBMS_LOB package which provides additional functionality on the CLOB column. But it doesn't write to a file. You can also use the UTL_FILE package to write column's data to a file.

Oracle does have a Migration Toolkit for download on Technet, but unfortunately, there is no support for migrating from FoxPro. People with FoxPro typically do one of two things. One, dump the data from FoxPro into a comma-delimited flat file for each table. Then use SQL*Loader to import the data into Oracle. Or two, use ODBC to push the data into Oracle.

This was first published in September 2003

Dig deeper on Oracle database design and architecture



Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.



Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: