Home » SQL & PL/SQL » Client Tools » Comparison of object structures in different environment (Oracle, 10.2.0.2.0 , unix)
Comparison of object structures in different environment [message #465195] Tue, 13 July 2010 03:07 Go to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Hi,

I want to determine the process which will
give the difference of object structures in different environments.

Can somebody tell me how to do that ?

Thanks
Re: Comparison of object structures in different environment [message #465208 is a reply to message #465195] Tue, 13 July 2010 03:50 Go to previous messageGo to next message
halim
Messages: 99
Registered: September 2008
Location: Bangladesh
Member


Your Question is not clear ?

Re: Comparison of object structures in different environment [message #465226 is a reply to message #465195] Tue, 13 July 2010 04:13 Go to previous messageGo to next message
Michel Cadot
Messages: 58607
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use DBMS_METADATA abnd "diff".

Regards
Michel
Re: Comparison of object structures in different environment [message #465240 is a reply to message #465226] Tue, 13 July 2010 05:00 Go to previous messageGo to next message
Solomon Yakobson
Messages: 1962
Registered: January 2010
Senior Member
Tools like Toad and OEM have very good comparison tools.

SY.
Re: Comparison of object structures in different environment [message #465242 is a reply to message #465240] Tue, 13 July 2010 05:05 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member


Thanks,


Can you give me the steps using toad ?
Re: Comparison of object structures in different environment [message #465244 is a reply to message #465242] Tue, 13 July 2010 05:11 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
you can use SQL developer from oracle

Manu :- Tools->Database Diff it will ask you for source and destination connection and all types of objects to diff
say you just want to diff Tables etc
Re: Comparison of object structures in different environment [message #465265 is a reply to message #465244] Tue, 13 July 2010 05:57 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member


Thank you..

Similarily can you provide the steps in toad.
Re: Comparison of object structures in different environment [message #465274 is a reply to message #465265] Tue, 13 July 2010 06:19 Go to previous messageGo to next message
cookiemonster
Messages: 10848
Registered: September 2008
Location: Rainy Manchester
Senior Member
Most of use don't use toad. Check the menus for anything that sounds like a comparison tool.
Also check toad help.
Re: Comparison of object structures in different environment [message #465291 is a reply to message #465244] Tue, 13 July 2010 07:28 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Rahul,

I checked the steps in SQL developer but there is
no such options available in sql developer.

can you check from your end?
Re: Comparison of object structures in different environment [message #465333 is a reply to message #465291] Tue, 13 July 2010 12:19 Go to previous messageGo to next message
babuknb
Messages: 1717
Registered: December 2005
Location: NJ
Senior Member

Balaji; Why your not trusing custom script? You can write using DBA_OBEJCTS, DBA_VIEWS, DBA_CONSTRAINTS using Oracle Set Operation

>>I checked the steps in SQL developer but there is no such options available in sql developer.

We don't know which version your using

Also; This question already asked here. http://www.orafaq.com/forum/t/66818/0/

Babu
Re: Comparison of object structures in different environment [message #465338 is a reply to message #465333] Tue, 13 July 2010 12:26 Go to previous message
babuknb
Messages: 1717
Registered: December 2005
Location: NJ
Senior Member

>>Most of use don't use toad

I agree with you.

@Balaji; Schema Compares already available in Toad (7.6 (may its old one) ) Have you searched menus? Mean while I found something from DBA Menu -> Compare Schemas

Babu
Previous Topic: Move from DEV to TEST env. - TOAD or SQL DEVELOPER
Next Topic: ER Studio
Goto Forum:
  


Current Time: Tue Jul 29 06:28:19 CDT 2014

Total time taken to generate the page: 0.22280 seconds