Merging oracle two table from different schema into new schema

One Star

Merging oracle two table from different schema into new schema

Hi, could someone guide me in the right path as im newbie using this application i know a bit of MSSQL DTS it seems look the same but the methods is about confusing me. I have a similar scenario like the tables below. Where my main purpose is to merge two database and create a new database with combined data records. Could someone guide me to the step to achieve this task which component should i use.

ORACLEDB1
TBLMASTER - Master list table
ID FIELD1
1 CAR1
2 CAR2
3 BLACK
4 WHITE
5 HAWK
6 TIGER
TBLASSOC - Association table parent<->child
P_ID C_ID
1 4
2 5
3 6
ORACLEDB2
TBLMASTER - Master list table
ID FIELD1
1 CAR3
2 CAR4
3 BLUE
4 YELLOW
5 WHALE
6 FIN
TBLASSOC - Association table parent<->child
P_ID C_ID
1 4
2 5
3 6

ORACLEDB3 FINALOUTPUT
TBLMASTER - Combined master list table
ID FIELD1
1 CAR1
2 CAR2
3 BLACK
4 WHITE
5 HAWK
6 TIGER
7 CAR3
8 CAR4
9 BLUE
10 YELLOW
11 WHALE
12 FIN
TBLASSOC - Combined Association table parent<->child
P_ID C_ID
1 4
2 5
3 6
7 10
8 11
9 12

Any help is highly appreciated.
Thanks