RE: Compare Schemas
- From: "Herring Dave - dherri" <Dave.Herring@xxxxxxxxxx>
- To: <rgramolini@xxxxxxxxxxxxxxx>, <rstauffer@xxxxxxxxxxxxxxxxxxxx>, <Meenakshi.Aggarwal@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 29 Nov 2005 12:13:18 -0600
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:
