Home » SQL & PL/SQL » SQL & PL/SQL » find difference in two schemas (oracle 11 g)
find difference in two schemas [message #578208] Mon, 25 February 2013 12:01 Go to next message
Messages: 202
Registered: April 2006
Senior Member
I want to find difference between the objects(tables(columns,constraints), views, sequences) in two schemas. One schema is staging and one is development . In development lot of changes are made , Is there a script or a opensource tool which will bring out the difference in columns, constraints in each table and sequences , views etc.
Re: find difference in two schemas [message #578210 is a reply to message #578208] Mon, 25 February 2013 12:05 Go to previous messageGo to next message
Messages: 24269
Registered: January 2009
Senior Member
when all else fails Read The Fine Manual

Re: find difference in two schemas [message #578267 is a reply to message #578210] Tue, 26 February 2013 04:25 Go to previous message
Messages: 132
Registered: November 2011
Senior Member
below may help

Previous Topic: How we can declare a global Variable in Package Body(Not Spec)
Next Topic: ORA-01830: date format picture ends before converting entire input string
Goto Forum:

Current Time: Wed Nov 25 17:46:48 CST 2015

Total time taken to generate the page: 0.08521 seconds