I second this solution (dump to fixed-width or comma-separated file in
DB2, then use sqlloader to populate tables in Oracle). I checked
MetaLink and Oracle also seems to second it. Note 200288.1 (revised
7-Aug-2002) states "The Transparent Gateway for DB2 is not suitable for
migrating a complete DB2 database to an Oracle database."
Jim Kennedy wrote:
> I would think so. You can use sqlloader in Oracle to load the data into
> Oracle. You could use a select statement and spool it to a file in DB2.
> Jim
> "david chan" <davidchantf_at_hotmail.com> wrote in message
> news:dca7348f.0209240538.369c3b77_at_posting.google.com...
>
>>Hi,
>> What's the best way to transfer data from DB2 to Oracle 8.1.7? There
>>are only four tables in DB2 with a few thousands records. Can DB2 do a
>>dump data to text file then Oracle import the file?
>>
>>Thanks.
>>David
>
Received on Tue Sep 24 2002 - 11:58:22 CDT
