Re: DBF to Oracle

you can directly load dbase III tables into oracle when your infile line looks like this:

INFILE "NAW_OUD.DBF" "DB3 482" where 482 stands for the number of characters for each line. Count these with a hex-editor

Peter

River heeft geschreven in bericht <3734EC64.98B65570_at_vol.net>...
>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 Tue May 11 1999 - 10:04:28 CDT