OraFAQ Forum: Server Administration » Schema difference Script (merged 3)

Home » RDBMS Server » Server Administration » Schema difference Script (merged 3)

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

Schema difference Script (merged 3) [message #352262]

Mon, 06 October 2008 22:27

niteshnandawat
Messages: 4
Registered: October 2008
Location: bangalore

Junior Member

Hi guys,

I want to compare schema test and test1. need to compare both and apply all the changes to test. let me know if there is ant script or tool is avaiable.

Thanks
Nitesh

Report message to a moderator

Re: Schema diffrence Script [message #352266 is a reply to message #352262]

Mon, 06 October 2008 22:35

rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India

Senior Member

Which tool you are using for debugging ?
It is available in almost all 3rd party tools .

Thumbs Up

Rajuvan.

Report message to a moderator

Re: Schema diffrence Script [message #352267 is a reply to message #352266]

Mon, 06 October 2008 22:40

niteshnandawat
Messages: 4
Registered: October 2008
Location: bangalore

Junior Member

toad can give the diffrence script between both the schema, but I want the same in linux plateform using some command line utility or Script as I need to automate this task. So Please help me out in this

Thanks
Nitesh

Report message to a moderator

Re: Schema diffrence Script [message #352278 is a reply to message #352262]

Mon, 06 October 2008 23:19

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

Senior Member
Account Moderator

Compare what? Table list? Table structure? Object? Data? Storage?...

Regards
Michel

Report message to a moderator

Re: Required Schema Diffrence Script [message #352280 is a reply to message #352262]

Mon, 06 October 2008 23:21

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

Senior Member
Account Moderator

Don't multipost your question.

Regards
Michel

Report message to a moderator

Re: Schema difference Script (merged 3) [message #352434 is a reply to message #352262]

Tue, 07 October 2008 11:10

niteshnandawat
Messages: 4
Registered: October 2008
Location: bangalore

Junior Member

Hi,

Basically I want to comapre all the objects in schema including table structure bot not data.

Thanks
Nitesh

Report message to a moderator

Re: Schema difference Script (merged 3) [message #352493 is a reply to message #352434]

Wed, 08 October 2008 01:15

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

Senior Member
Account Moderator

If you want to do it in SQL script, query dba_tables and db_tab_columns.

Regards
Michel

Report message to a moderator

Re: Schema difference Script (merged 3) [message #352518 is a reply to message #352493]

Wed, 08 October 2008 02:45

niteshnandawat
Messages: 4
Registered: October 2008
Location: bangalore

Junior Member

Hmm,

But dear I need a shell script which can find out the diffrence and can genrate a sql script.

Thanks
Nitesh

Report message to a moderator

Re: Schema difference Script (merged 3) [message #352521 is a reply to message #352518]

Wed, 08 October 2008 02:53

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

Senior Member
Account Moderator

Post you already did.
You don't expect we will do all the work for you, don't you?

Regards
Michel

Report message to a moderator

Re: Schema difference Script (merged 3) [message #352535 is a reply to message #352262]

Wed, 08 October 2008 05:04

mengxb001
Messages: 4
Registered: December 2007
Location: China

Junior Member

you can use toad to compare the schema difference.

Report message to a moderator

Re: Schema difference Script (merged 3) [message #352536 is a reply to message #352535]

Wed, 08 October 2008 05:10

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

Senior Member
Account Moderator

Please read all the answers BEFORE posting. It is useless to repeat an answer that was rejected.

Regards
Michel

Report message to a moderator

Previous Topic:	Resize datafile
Next Topic:	How to read statspack results

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 17:41:39 CST 2024