We are unifying data from assorted Foxpro Apps and versions (one for each department) into a central Oracle DB. Each of the versions gets a space of it's own, in the new format, and shares a common interface. Upsizing will not work for those reasons.
The oringinal method of importing was to bring the table into VFP 6, re-create the remote view to Oracle for the correct department, and use a prg to loop through the VFP table and insert each record into Oracle. We did it this way because the field names were not consistent, anf VFP uses fixed width and we are usiong VARCHAR2's.
Basicly:
USE vfp_data in 1
use ora_data in 2
select 1
go top
do while !EOF()
scatter memvar
insert into ora_data(b,c,d,....)
Values(RTRIM(m.b),RTRIM(m.c),TODATE(m.othername), m.e.....)
skip 1 in 1
loop
enddo

This process takes about 2 seconds per record, much too slow with many thousands of records. (last import, 60+ hours)
We then tried using UTL (Oracles ODBC import tool) with no luck, probably because there are no decent examples of how to do it.
We are currently working on SQLLoad, but there seems to be something wrong with it, I keep getting errors and no imports