There are two schemas in Oracle11g. For example db1 and db2.
They have same structure of tables and different data to each other.
Now I want to merge data on db1 with data on db2 with no duplication.
But I can’t, duplication is happened.
I tried two different ways like bellow:
Import from dumpFile.db1 into db1 then import from dumpFile.db2 into db1.
After import data into both schemas and executo direct path insert.
insert/*+ APPEND */ into db1.myTable (SELECT * FROM db2,myTable);.
Are there good way to merge without duplication?