Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DBF to Oracle
Hello,
I haven't used DBASE seriously.
Is the following sentences executed under DBASE shell?
"USE dbffile
COPY TO textfile.sdf DELIMITED WITH BLANK"
then load the "textfile.sdf" by SQL*LOADER? If it is not so inconvenient to you, I hope you to send me the script.
Thanks you very much!
River
wychan_at_vol.net
Denis ALEXANDRE wrote:
> From DBASE:
>
> USE dbffile
> COPY TO textfile.sdf DELIMITED WITH BLANK
>
> Then load with SQL*LOADER
>
> I have had written 12 years ago a general purpose script to export/import
> DATA STRUCTURE and DATA from/to DBF/Oracle DB but can't find it now. If
> needed I can recreate it for you :-)
>
> River <wychan_at_vol.net> a écrit dans le message :
> 37330795.B5857941_at_vol.net...
> > Hello,
> >
> > Is there a tool to convert the data in .dbf to Oracle table ?
> >
> > Thanks for any advice,
> > River
> > wychan_at_vol.net
> >
> >
Received on Sat May 08 1999 - 21:01:08 CDT