#FOXPRO 2.6 FCREATE CODE#

sql file and run it from SQL*Plus, it will prompt you for the directory path where the FoxPro table is, the name of the FoxPro. If you copy the entire script below to a.

#FOXPRO 2.6 FCREATE CODE#

I have taken Tom Kyte's original code, applied Mattia Rossi's modifications, and made some additional modification to produce the code below. Link above updated by Barbara Boehmer on October 22, 2007 If your tables are small, this is the most convenient. However, it is much slower than SQL*Loader. It is convenient in that it can be used to automatically create the Oracle tables of comparable structure and you don't need to create any SQL*Loader control files. The utility is intended for DBASE files, so you will need to apply the modifications for FoxPro by Mattia Rossi. Please click on the link below for a nice free utility from Tom Kyte. There are various other possibilities, such as ODBC or some third-party utility. This is the method that I routinely use with FoxPro 2.6 for DOS and Oracle 8.1.7.

Prior to doing this, you will need to create Oracle tables of comparable structure and SQL*Loader control files. If you are using Oracle 8i or earlier, the fastest-running method will probably be copying or listing the FoxPro tables to text files and using Oracle's SQL*Loader utility to load the data in the text files into Oracle tables. If you are using Oracle 9i, then you may be able to use external tables.

Foxpro 2.6 fcreate