Re: Comparing Schemas

From: Maheshwara Rao, L., Teki <teki01_at_mediaone.net>
Date: Fri, 13 Apr 2001 08:44:26 GMT
Message-ID: <K%yB6.10113$%_1.2308099@typhoon.ne.mediaone.net>

Subtract allows only for new objects that are not present. Take a case where in schema A -->Table1 and schema B-->Table1. If B.Table1 contains more columns than A.Table1, then subtract would not point out this difference.

Oracle EM, Change Management Module -- compares the schemas and points out all the differences.

Alternately, you can write script.

Rao
"Daniel A. Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3AD67B45.154537A4_at_exesolutions.com...
> There probably are ... but there is hardly a need. Just do a SUBTRACT from
> user_tab_columns from one with user_tab_columns from the other. And the
> same thing with any other views that might interest you such as
> USER_OBJECTS, USER_VIEWS, USER_CONSTRAINTS, USER_INDEXES, etc.
>
> Daniel A. Morgan
>
>
> Jim Poe wrote:
>
> > Are there any tools or scripts that can report differences between two
> > schemas in two databases?
> >
> > --
> > Jim Poe (jpoe_at_fulcrumit.com)
>
Received on Fri Apr 13 2001 - 03:44:26 CDT