In TDP, you can do the following to import data from DB2 table in to the Oracle table:
1. Connect to your Oracle database.
2. Go to the menu Tools | Import | Import Wizard
3. Click on Add Query
4. Select your DB2 database from the top and input your query and click on Next
5. Now select your Oracle schema and table to import the data into.