OraFAQ Forum: Client Tools » Script to compare two schemas from different instance of DB

Home » Other » Client Tools » Script to compare two schemas from different instance of DB (ORACLE 11G)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Script to compare two schemas from different instance of DB [message #547028]

Sun, 11 March 2012 14:27

Rony123
Messages: 14
Registered: December 2006

Junior Member

Hi

Problem situation:

There are two different DBs having similar schema.
Need to compare the rows in the tables and insert in the
1st DB whatever is different in 2nd DB.
Can anyone help me with a tool support or script?

Can I choose which rows to insert which to discard from 2nd DB
in 1st DB. Confused