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
miroconnect@yahoo.com
Messages: 199
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
BlackSwan
Messages: 22839
Registered: January 2009
Senior Member
when all else fails Read The Fine Manual

http://www.oracle.com/pls/db111/search?word=dbms_comparison&partno=
Re: find difference in two schemas [message #578267 is a reply to message #578210] Tue, 26 February 2013 04:25 Go to previous message
rishwinger
Messages: 132
Registered: November 2011
Senior Member
below may help

http://www.oracle-base.com/dba/miscellaneous/compare_schemas.sql
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: Tue Sep 30 19:58:59 CDT 2014

Total time taken to generate the page: 0.08909 seconds