Ask the Expert

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?

    Requires Free Membership to View

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: