Re: Compare 2 Oracle schemas!

Thanks for your response.
Of course, that all the info can be found in user_objects, user_tab_columns, user_indexex, user_contraints, user_triggers, user_source, user_views views. Even it's not hard to write is time consuming, and I try to find a script already written.

Thanks,
Petre

Sybrand Bakker wrote in message <3637617C.32643BF8_at_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:33:52 CST