Re: Comparing Schemas

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Thu, 12 Apr 2001 21:06:29 -0700
Message-ID: <3AD67B45.154537A4@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 Thu Apr 12 2001 - 23:06:29 CDT