Re: Schema Description

From: Andrew Protasov <oracle_at_protasov.kiev.ua>
Date: Mon, 9 Nov 98 19:32:57 +0200
Message-ID: <AB9ToHsK42@protasov.kiev.ua>

Hi,

I do not have a script, but you can try my Schema Comparison:

http://protasov.simplenet.com

It is important: you must have your schemas at one server or have database links in the case of different servers. If it is not appropriate to your needs, try Quest Software Schema Manager:

http://www.quests.com

Someone told about TOAD that it can compare schemas too:

http://www.toadsoft.com

As far as I remember there is such a script on Oracle Magazine web site in their archive too.

Andrew Protasov

> Hi all,
>
> I need a SQL script that provides me with the
> description of a particular schema or instance
> so I can run it elsewhere and find out their differences.
>
> This must be quite exact. I need to spot any change on field,
> trigger or index object. I bet I need to query user_objects
> but an experienced advice would be much appreciated.
>
> Thanks in advance
>
> Igor
Received on Mon Nov 09 1998 - 11:32:57 CST