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: Tim Shute <tshute_at_nisoft.co.uk>
Date: Wed, 12 May 1999 09:27:27 +0100
Message-ID: <049F56710FD6D211B08D006097A4426B0323A3@orion>


We've done a few different things in the past. 1. If the fields in the .dbf match your Oracle table exactly, create a delimited text file and then SQL*Load it. 2. If you have to do some re-mapping, use something like Delphi to read a .dbf record, re-format it and write it to the Oracle table. 3. If you want to do the mapping at the Oracle end create a table in Oracle that matches the .dbf, create a delimited file and SQL*Load the data, then use Forms or just PL/SQL to re-map the data into the real Oracle table.

HTH --
Tim Shute
Software Engineering Manager

NiSoft (UK) Limited
Unit 8, 31 Ballynahinch Road, Carryduff, BELFAST BT8 8EH Internet: www.nisoft.co.uk

River <wychan_at_vol.net> wrote in message news:37330B80.A324181B_at_vol.net...
> Hello,
>
> How to convert the data in a .dbf file to Oracle table?
>
> Thanks for any advice,
> River
> wychan_at_vol.net
>
Received on Wed May 12 1999 - 03:27:27 CDT

Original text of this message

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