This note will detail the steps required to move data from a DB2 9.7 UDB running on Linux to an Oracle 10g database also running on Linux using the migration capabilities provided by Oracle SQL Developer.
I have used SQL Developer 126.96.36.199.45 which I think is the latest version available for download. I tested moving a 2 million row table which took about 50 minutes.
Have a look at this note which shows all the steps taken for the operation including step by step screenshots.
Appreciate your feedback and kindlly share your experiences in such heterogenous data load exercises with the rest of the community.
Last Update: October 14, 2010