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

Home » SQL & PL/SQL » Client Tools » Script to compare two schemas from different instance of DB (ORACLE 11G)

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

Switch to threaded view of this topic

Create a new topic

Submit Reply

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

Confused

BR,
Rony

Report message to a moderator

Send a private message to this user

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

Barbara Boehmer
Messages: 7683
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

Send a private message to this user

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

John Watson
Messages: 3181
Registered: January 2010
Location: Global Village

Senior Member

The dbms_comparison package is designed for this.

Report message to a moderator

Send a private message to this user

Switch to threaded view of this topic

Create a new topic

Submit Reply

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 19 15:16:53 CDT 2013

Total time taken to generate the page: 3.47847 seconds