Re: from DB2 to Oracle8

From: Jim Harrison <jim_at_colway.net>
Date: 2000/06/30
Message-ID: <8jj3ub$1i$1@news6.svr.pol.co.uk>#1/1

You have a few options:

SQL*Loader - very fast, but more work. i.e. Select the data from your DB2 tables into a flat file, then use SQL*Loader to insert into Oracle.

Generate lots of insert statements eg: SELECT 'INSERT INTO ORA_TAB (col1, col2...) VALUES('||col1||','||col2||',...)' FROM DB2_TAB; Then run the SQL script against your Oracle table.

BMC software used do a lot of good software for DB2. Maybe they already have something available.

Jim Harrison
Colway Software and Design
www.colway.net Received on Fri Jun 30 2000 - 00:00:00 CDT