Re: Conversion of data from Foxpro to Oracle

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: 2000/09/20
Message-ID: <39C84226.E479DD44@edcmail.cr.usgs.gov>#1/1

The easiest thing to do is to use one of Foxpro's utilities to dump the records to a flat file. Either make the records character delimited (like ',') or a fixed column width. Then use SQL*Loader to read the flat file into a table (or two). Refer to the Oracle Docs for more information on SQL*Loader.

HTH,
Brian

Zeeshan Basharat wrote:
>
> I have a problem with me.
> I have a database file in Fox DBF file which has 200 thousands record .
> I want to transfer all the data in Oracle's Table. What should I do?
> Please help me if you can.
> Thanks in advance.
>
> Bye,
> Zeeshan Basharat.
> ICQ:50080409
> ************

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================

Received on Wed Sep 20 2000 - 00:00:00 CDT