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@xxxxxxxxxx <mailto:dherri@xxxxxxxxxx> >

-------------------------------------

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ruth Gramolini
Sent: Tuesday, November 29, 2005 10:56 AM
To: rstauffer@xxxxxxxxxxxxxxxxxxxx; Meenakshi.Aggarwal@xxxxxxxxxxxxx;
oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Stauffer, Robert G
Sent: Tuesday, November 29, 2005 11:49 AM
To: Meenakshi.Aggarwal@xxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxxx

 

 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Aggarwal, Meenakshi
Sent: Tuesday, November 29, 2005 11:43
To: oracle-l@xxxxxxxxxxxxx
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.

 

***************************************************************************
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be legally
privileged.

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.
****************************************************************************

Other related posts: