Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Compare Schemas
Although CM is a good concept, its got a few large downfalls, at least
under 9i. For example, it doesn't recognize hash and list partitioning.
Also, its rather cumbersome to setup as a regularly scheduled job. Not
sure if 10g addressed any of this.
Dave
Dave Herring, DBA
Acxiom Corporation
3333 Finley
Downers Grove, IL 60515
wk: 630.944.4762
<mailto:dherri_at_acxiom.com <mailto:dherri_at_acxiom.com> >
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ruth Gramolini
Sent: Tuesday, November 29, 2005 10:56 AM
To: rstauffer_at_decommunications.com; Meenakshi.Aggarwal_at_fishersci.com;
oracle-l_at_freelists.org
Subject: RE: Compare Schemas
OEM has a "compare database objects" module under the Change Manager, If you have OEM, take a look at this.
HTH, Ruth
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Stauffer, Robert G
Sent: Tuesday, November 29, 2005 11:49 AM
To: Meenakshi.Aggarwal_at_fishersci.com; oracle-l_at_freelists.org
Subject: RE: Compare Schemas
If you're using TOAD, it has a Compare Schemas tool. At least the purchased version does. I don't know if the freebie contains it or not.
Bob Stauffer
DBA
D&E Communications
Ephrata, PA, USA
717-738-8737
rstauffer_at_decommunications.com
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Aggarwal, Meenakshi
Sent: Tuesday, November 29, 2005 11:43
To: oracle-l_at_freelists.org
Subject: Compare Schemas
Hi,
Is there a preferred tool/script available to compare schemas.
Thanks
Meenakshi
**DISCLAIMER
This e-mail message and any files transmitted with it are intended for
the use of the individual or entity to which they are addressed and may
contain information that is privileged, proprietary and confidential. If
you are not the intended recipient, you may not use, copy or disclose to
anyone the message or any information contained in the message. If you
have received this communication in error, please notify the sender and
delete this e-mail message. The contents do not represent the opinion of
D&E except to the extent that it relates to their official business.
If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.
If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system.
Thank You.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Nov 29 2005 - 12:16:34 CST
![]() |
![]() |