>Once you get the data, how do you get it into Oracle? If it an actual dump file created by the Oracle EXPort utility, you will have to run the Oracle IMPort utility to get it into Oracle. If that is so, then you are stuck with what has already been sugggested.
>
>If you are using the SQL Loader utility to get the data into Oracle, then you can by-pass the getting the data into Oracle step, and import the data directly into VFP.
>
>Data files used by the SQL Loader utility are delimited files. There will usually be a file definition file that has the structure [field name order] that will be a big help in doing your APPEND FROM DELI.
>

Hello Mark, well I am not an oracle expert, but the files that we get via FTP are a .dmp and .log file. They are given to the Oracle people to get into the database. I tried to read the .dmp file (fread), but found it contained special characters and not really a delimited file. What I saw in the .dmp from the fread what statements that resemble SQL Create Table and Insert.

I was hoping to just rread the .dmp, but I dont think I can do it.


>>I need some advice on how to go about doing this.
>>
>>My group was given the data as a dump from oracle and we loaded it into our Oracle system. Now I want to know what is the best way to get the data out of Oracle and into our VFP database. The data is huge as one table has 5 million records and the next size is 500,000 records. The data will be given to us twice a week and I am tasked to get the data out of Oracle and into our VFP system. As I have no Oracle experience, I was wondering what would be the best way to do this? Any suggestions would be appreciated, but if you do give one that involves doing something inside of Oracle can you provide a detail explanation. Because as I said I do not know Oracle. What I am hoping for is a fairly automated way of getting this done, so that it can run unattended at night.
>>
>>TIA