script for comparing two schemas in two databases

2002-05-29 Thread Daiminger, Helmut
Title: script for comparing two schemas in two databases Hi! Does anybody out there have a script that allows me to compare two schemas in two different databases (i.e. development and production db)? This is 8.1.7 on Sun Solaris. Thanks, Helmut

Re: script for comparing two schemas in two databases

2002-05-29 Thread G . Plivna
two schemas in two databases [EMAIL PROTECTED

RE: script for comparing two schemas in two databases

2002-05-29 Thread Mark Leith
Attached.. HTH Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] ===

RE: script for comparing two schemas in two databases

2002-05-29 Thread Stephane Faroult
Hi! Does anybody out there have a script that allows me to compare two schemas in two different databases (i.e. development and production db)? This is 8.1.7 on Sun Solaris. Thanks, Helmut There's something in the DBA tool kit at http://www.oriole.com. Forgot the exact name. Regards,

Re: script for comparing two schemas in two databases

2002-05-29 Thread Alexandre Gorbatchev
Title: script for comparing two schemas in two databases Hi Helmut, There are some tools for it. For example, Oracle Change Manager Pack for OEM. This is a tough task for script, because too many factors are involved. HTH, Alexandre - Original Message - From: Daiminger

RE: script for comparing two schemas in two databases

2002-05-29 Thread Farnsworth, Dave
Thanks for the script Mark! Dave -Original Message- Sent: Wednesday, May 29, 2002 4:53 AM To: Multiple recipients of list ORACLE-L Attached.. HTH Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F:

RE: script for comparing two schemas in two databases

2002-05-29 Thread Michael P Sale
OEM's Change Management pack does just that. It also allows you to compare it with previous snapshots and implement them into production in a scheduled, controlled manner. Regards, Michael Sale Co-author: Oracle 9i on Windows 2000 Tips and Techniques -Original Message- Helmut Sent:

RE: script for comparing two schemas in two databases

2002-05-29 Thread kkennedy
Title: script for comparing two schemas in two databases Years ago, I found a script on Metalink that worked decently after a few bug fixes. It was written by Ottar Sorland for use withOracle 7.3. I still occasionally use it and cansend my patched (but still not perfect) version if youneed

RE: script for comparing two schemas in two databases

2002-05-29 Thread Simon . Anderson
The Oracle Enterprise Manager 'Change Manager' does a good job of schema comparisons, and has an easy point-and-click interface that shields you from having to know what you're doing ;-) The downside is that it can be a pain to get oem set up and working. I've never tried it's more advanced

RE: script for comparing two schemas in two databases

2002-05-29 Thread Ron Rogers
Kevin, You should download the ver 7.3 of TOAD. It has a lot of improvements that You might find handy. Ron ROR mª¿ªm [EMAIL PROTECTED] 05/29/02 01:24PM Years ago, I found a script on Metalink that worked decently after a few bug fixes. It was written by Ottar Sorland for use with Oracle

RE: script for comparing two schemas in two databases

2002-05-29 Thread Kevin Lange
I came to that conclusion as well. I especially like the fact that it even creates a sync script after the compare. I just used it on two of our DBs. Worked great. -Original Message- Sent: Wednesday, May 29, 2002 4:54 PM To: Multiple recipients of list ORACLE-L Kevin, You should