Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DBF to Oracle
Hi Oleg,
so, where is the db3prep?
Thanks for any advice,
River
wychan_at_vol.net
Oleg Tsibulnyak wrote:
> 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 Sat May 08 1999 - 21:42:25 CDT