Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: .dbf to Oracle

Re: .dbf to Oracle

From: Erwin Dondorp <erwindon_at_wxs.nl>
Date: Sun, 09 May 1999 03:01:00 +0200
Message-ID: <3734DE4C.7A1C8E33@wxs.nl>


> River wrote:
> How to convert the data in a .dbf file to Oracle table?

The best way I can think of is to write a program that does 2 things: - It reads the header of the .dbf file and generates a SQL*Loader control file
- It reads the rest of the .dbf file and generates a matching SQL*Loader data file.
Then run SQL*Loader to load the data into the database.

The fileformat for a .dbf file is well-known.

--
Erwin Dondorp
<http://www.wxs.nl/~erwindon> Received on Sat May 08 1999 - 20:01:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US