Re: DBF to Oracle

From: Oleg Tsibulnyak <tsibulnyak_at_my-dejanews.com>
Date: Fri, 07 May 1999 17:56:14 GMT
Message-ID: <7gv9fr$kv5$1@nnrp1.deja.com>

Hi River,
You can use the tool SQL*Loader, for example (it's a console utilites): sqlldr scott/tiger control=a.ctl

where file a.ctl contain

load data
infile '<file name>.dbf' "db3 <record size+1 byte(deleted flag)>" into table <oracle table name> WHEN (1)!='*' (<oracle table field 1> position(2:n1),

<oracle table field 2> position(n1+1:n2),
<oracle table field 3> position(n2+1:n3),
<oracle table DATE field 4> position(n3+1:n4) date(8) "YYYYMMDD")

For creation control file (xxx.ctl) you can use the utility db3prep.

> Hello,
>
> Is there a tool to convert the data in .dbf to Oracle table ?
>
> Thanks for any advice,
> River
> wychan_at_vol.net
>
>

--
Oleg Tsibulnyak

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri May 07 1999 - 12:56:14 CDT