OraFAQ Forum: Client Tools » Comparison of object structures in different environment

Home » Other » Client Tools » Comparison of object structures in different environment (Oracle, 10.2.0.2.0 , unix)

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

Comparison of object structures in different environment [message #465195]

Tue, 13 July 2010 03:07

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

Report message to a moderator

Re: Comparison of object structures in different environment [message #465208 is a reply to message #465195]

Tue, 13 July 2010 03:50

halim
Messages: 100
Registered: September 2008

Senior Member

Your Question is not clear ?

Report message to a moderator

Re: Comparison of object structures in different environment [message #465226 is a reply to message #465195]

Tue, 13 July 2010 04:13

Michel Cadot
Messages: 68775
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Use DBMS_METADATA abnd "diff".

Regards
Michel

Report message to a moderator

Re: Comparison of object structures in different environment [message #465240 is a reply to message #465226]

Tue, 13 July 2010 05:00

Solomon Yakobson
Messages: 3305
Registered: January 2010
Location: Connecticut, USA

Senior Member

Tools like Toad and OEM have very good comparison tools.

SY.

Report message to a moderator

Re: Comparison of object structures in different environment [message #465242 is a reply to message #465240]

Tue, 13 July 2010 05:05

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Thanks,

Can you give me the steps using toad ?

Report message to a moderator

Re: Comparison of object structures in different environment [message #465244 is a reply to message #465242]

Tue, 13 July 2010 05:11

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

Report message to a moderator

Re: Comparison of object structures in different environment [message #465265 is a reply to message #465244]

Tue, 13 July 2010 05:57

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Thank you..

Similarily can you provide the steps in toad.

Report message to a moderator

Re: Comparison of object structures in different environment [message #465274 is a reply to message #465265]

Tue, 13 July 2010 06:19

cookiemonster
Messages: 13975
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.

Report message to a moderator

Re: Comparison of object structures in different environment [message #465291 is a reply to message #465244]

Tue, 13 July 2010 07:28

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?

Report message to a moderator

Re: Comparison of object structures in different environment [message #465333 is a reply to message #465291]

Tue, 13 July 2010 12:19

babuknb
Messages: 1736
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

Report message to a moderator

Re: Comparison of object structures in different environment [message #465338 is a reply to message #465333]

Tue, 13 July 2010 12:26

babuknb
Messages: 1736
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 13 02:14:20 CST 2026