Import Utility Without Duplication
459628Jan 17 2008 — edited Jan 17 2008I planning to export one Schema from an Oracle database (let say DB1) and I want to import it into another Oracle database (let say DB2). However, DB2 already has the exported Schema along with its contents (Tables and its data/records), but the data/records in the Tables is/are old. Therefore I want to import the data from DB1 into DB2 while ensuring that there will be no duplication in DB2, is that possible?
The reason for that because the mentioned Schema contains more than 1000 tables and it will be a hassle for me clearing all corresponding tables in DB2 before using the import utility.
I am running Oracle 9i R2 on Windows 2000 Server for both DBs.