Home » Other » 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

Report message to a moderator

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: 9105
Registered: November 2002
Location: California, USA
Senior Member
http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:941629680330

Report message to a moderator

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: 8977
Registered: January 2010
Location: Global Village
Senior Member
The dbms_comparison package is designed for this.

Report message to a moderator

Previous Topic: login with SYSDBA
Next Topic: Alternate solution to DB link
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 23 11:00:45 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.