Hi All,
I have some tables that are in Oracle 9i. I have created new tables in DB2 v 9.1.0.5 fixpack '5'. So, now I need to move/copy the data from the Oracle 9i tables to DB2 tables.
Can anyone please provide me the steps involved/processed when doing this data migration. Any links related to data migration from oracle to db2 tables material is much appreciated.

Oracle Version: Oracle 9i

DB2 Version: 9.1.0.5

OS version: AIX 5.3

Thanks

Option 1
1.export in to a flat file from Oracle database.
2.Import or load from flat file to the DB2 Database

Option 2:

Data warehouse tool to load the data from hierarchical databases

with federation = easy to setup
have a look at infocenter
http://publib.boulder.ibm.com/infoce...v9r5/index.jsp
and search for oracle federation

Agree, but extra licences are required. Just to convert I would unload the oracle tables into flat files and then load the data in db2.
I'm not familiar with orcale but an equivalent to "db2look" might be handy to convert the DDL.

Thanks guyzz for your replies..

The tablenames and columns names are different both in Oracle and Db2. So I have to map the data and then migrate..

So, any suggestions on this how to do?

Thanks All ..I appreciate..

have you considered using Migration Toolkit (MTK):
IBM Migration Toolkit - IBM Information Management

There is a pdf document "What to know when transfer Oracle data to DB2 with FastReader" which might be helpful http://www.wisdomforce.com/dweb/reso..._migration.pdf