Compare tables and insert the differnce into table

I have two tables say A in database X and A in database Y..I want to insert the records from table A in database Y into table A in X database.

i tried the minus option it gives unique constraint violated error...If i try append option in impdp still it gives same error..can any one help?

That means your MINUS statement is not returning right result set. Are you using DBLINK to use MINUS query?.

Yes..I am using DB link

Try using the merge command. you tell it how to handle conflicts. If a record does not exist there is an insert clause, if a record does exist there is an update clause, etc.

Quote:

---

Originally Posted by mohith2009

I have two tables say A in database X and A in database Y..I want to insert the records from table A in database Y into table A in X database.

i tried the minus option it gives unique constraint violated error...If i try append option in impdp still it gives same error..can any one help?

---

Chances are that table Y.A is a child table - is there a Referential Integrity constraint pointing to a parent table in Y database? e.g. FK?

If this is the case you have to insert the parent rows first.