Re: upgrading a schema

timasmith_at_hotmail.com wrote:
> Hi,
>
> I have an application using Oracle with a large (100+) number of
> tables. Are there any free/open source tools that can ease the process
> of updating the schema.
>
> Specifically I would like to compare a source and a target, determine
> the differences and the best way to update the target to be equivalent
> to the source - tables, columns, views, etc.
>
> thanks

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

A demo can be found in Morgan's Library at www.psoug.org.

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