Copy (Import) Data from Oracle Database To Another

[abdulladarwish]

I want to Copy a data from One oracle database to another.

I have checked Import/Export Utility but the problem is import utility doesn't support conflicts resolution techniques between rows.

For Example if there's a table in the source database have the same row key in the destination database. if i use 'Ignore' parameter with value = y, the destination table will have a duplicate rows.

I want to ask if there's another way to import data from oracle database to another with some mechanism of detecting the conflicts and resolve them?

[rski]

If table source is not so big you can define dblink and use merge statement when you load data into destinatinon table.

If source table is big then the best will be to import data from a file into some temp table, and then merge this temp table rows into destination table.

Here you can find info abt dblink http://docs.oracle.com/cd/B19306_01/...ments_5005.htm and merge statement http://docs.oracle.com/cd/B28359_01/...ments_9016.htm.