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: 25527
Registered: January 2009
Location: SoCal
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: Sat Jul 22 10:05:40 CDT 2017

Total time taken to generate the page: 0.18870 seconds