Home » SQL & PL/SQL » Client Tools » Script to compare two schemas from different instance of DB (ORACLE 11G)
Script to compare two schemas from different instance of DB [message #547028] Sun, 11 March 2012 14:27 Go to next message
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

BR,
Rony
Re: Script to compare two schemas from different instance of DB [message #547029 is a reply to message #547028] Sun, 11 March 2012 14:30 Go to previous messageGo to next message
Barbara Boehmer
Messages: 7975
Registered: November 2002
Location: California, USA
Senior Member
http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:941629680330
Re: Script to compare two schemas from different instance of DB [message #547402 is a reply to message #547028] Wed, 14 March 2012 03:07 Go to previous message
John Watson
Messages: 4523
Registered: January 2010
Location: Global Village
Senior Member
The dbms_comparison package is designed for this.
Previous Topic: login with SYSDBA
Next Topic: Alternate solution to DB link
Goto Forum:
  


Current Time: Tue Sep 02 17:47:05 CDT 2014

Total time taken to generate the page: 0.43669 seconds