Re: importing data from DB2 into ORACLE ?

In article <3pc68n$8be_at_caladan.restena.lu>, Torsten.Fassian_at_eurostat.cec.be (Torsten FASSIAN) says:
>
>In article <adamou.4.00112644_at_dorado.crpht.lu>,
> adamou_at_dorado.crpht.lu (Adel ADAMOU) wrote:
>>hi folks,
>>
>>i'd like to know what could be the best way to import data from a db2 into
>>oracle ?
>>
>>Thanks in advance.
>>
>>Adel.
>>
>>please email: adamou_at_dorado.crpht.lu
>>
>As salamu alaikum,
>
>If DB2 has a tool to dump your database file to a flat text file then the most
>convenient way is to use that and than import the data using SQL*Loader.
>
>Ma asalama,
>
>Torsten
>
>Torsten FASSIAN
>ORACLE DBA
>EUROSTAT (European Commission)

Use DB2's utility DSNTIAUL which will unload the data and produce load control cards for DB2's load utility. SQL*Loader's control cards are VERY similar. Worst case you might have to edit the control files a bit. Should be very easy.

Greg Flannery
Database Administration
Tennessee Valley Authority Received on Fri May 19 1995 - 00:00:00 CEST