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

    Login

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

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top