OraFAQ Forum: Server Administration » Comparing table structures in Oracle

Home » RDBMS Server » Server Administration » Comparing table structures in Oracle

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

Comparing table structures in Oracle [message #114690]

Tue, 05 April 2005 01:19

Mahesh P
Messages: 69
Registered: September 2004

Member

Hi All,
I want to compare only 10 tables structure in my oracle schema (of 250 tbls total) with other oracle schema. As i found in internet , there r tools which will compare the entire database schema.
can anyone help me out how can i do this.

Thanks & Regards,
Mahesh

Report message to a moderator

Re: Comparing table structures in Oracle [message #114718 is a reply to message #114690]

Tue, 05 April 2005 05:37

_simma_dba
Messages: 34
Registered: November 2003

Member

U can use TOAD but it's not free Sad

Report message to a moderator

Re: Comparing table structures in Oracle [message #114730 is a reply to message #114718]

Tue, 05 April 2005 06:39

Maaher
Messages: 7065
Registered: December 2001

Senior Member

If you have access to both USER_TAB_COLUMNS tables (on local and remote), you can write you're own script.

Look at this thread.

MHE

Report message to a moderator

Re: Comparing table structures in Oracle [message #115489 is a reply to message #114730]

Mon, 11 April 2005 20:47

andrew again
Messages: 2577
Registered: March 2000

Senior Member

OEM also has a good (but not bullet-proof) schema comparison tool. The disadvantage is that it needs to have a management server repository available.

Report message to a moderator

Previous Topic:	Droping redolog file?
Next Topic:	Is ASM worth the trouble?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 25 03:31:40 CST 2025