Re: how to transfer data to Oracle 8.1.7?

From: Chris Forbis <chrisforbis_at_yahoo.com>
Date: 25 Sep 2002 09:28:19 -0700
Message-ID: <f2dc430d.0209250828.b3ed81f@posting.google.com>

David,

Don;t know your data, but in many cases on a small db it is easy to do something like this:

SELECT 'INSERT INTO ORACLETABLENAME (c1,c2,c3)' VALUES('||COLUMN1||','||COLUMN2||','||COLUMN3||');' FROM DB2Table1;

It is quick and works real well, without having to learn new things. (Now might not work for all data enviroments)

Something like this will make a script that you can run on oracle to put the data in.

Chris

davidchantf_at_hotmail.com (david chan) 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 Wed Sep 25 2002 - 11:28:19 CDT