Re: upgrading a schema

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 19 Sep 2006 08:05:02 -0700
Message-ID: <1158678301.677432@bubbleator.drizzle.com>

davdonin wrote:
> DA Morgan wrote:

>> The capability is built into the database in the DBMS_RECTIFIER_DIFF
>> package.

>
> Daniel, the author is looking to compare schemas, not data I think.
>
> I have not come across a free product, which does this.
>
> Quest has Schema Manager product, which allows to compare
> schemas/baselines. It also allows to manage data. See
> http://www.quest.com/schema_manager/ for more details.
>
> Oracle Enterprice Manager has Change Management Pack, which allows to
> do the same. For more details please refer to Enterprise Manager
> documentation.
>
> Denis

Then how about:

SELECT object_name
FROM user_objects
INTERSECT
SELECT object_name
FROM user_objects_at_remote;

SELECT object_name
FROM user_objects
MINUS
SELECT object_name
FROM user_objects_at_remote;

and again with USER_TAB_COLUMNS.

-- 
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group

Received on Tue Sep 19 2006 - 10:05:02 CDT