Re: Compare 2 Oracle schemas!

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 28 Oct 1998 19:25:00 +0100
Message-ID: <3637617C.32643BF8@sybrandb.demon.nl>

This is a very rough one but it does work

select * from dba_objects o1
where owner = <owner1>
minus
select * from dba_objects o2
where owner = <owner2>;

This of course applies to objects only. To compare individual columns the same principle can be used for dba_tab_columns
The same for indexes.
In this case you will need to replace the * by something making more sense (as long as you want to compare conceptual info only). Make sure both select lists are the same if you do this.

Hth,

Sybrand Bakker, Oracle DBA

Petre Alexandrescu wrote:

> I try to find a script to compare two Oracle schemas and report all
> differences.
>
> Thanks,
> Petre
Received on Wed Oct 28 1998 - 12:25:00 CST