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 - 09:22:24 CDT
