Re: upgrading a schema

From: gazzag <gareth_at_jamms.org>
Date: 21 Sep 2006 05:26:13 -0700
Message-ID: <1158841573.505771.44430@b28g2000cwb.googlegroups.com>

timasmith_at_hotmail.com wrote:
> How does running diff on the two outputs help me generate the DDL
> statements to bring the target to the same level as the source?
>
> Without that there is not much value - I could write the same program
> in about 20 minutes.

How does not providing your version of Oracle allow us to help you effectively? ;-)

Depending on your answer to the above, check out the DBMS_METADATA package:

http://download-uk.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_metada.htm#i1015856 Received on Thu Sep 21 2006 - 07:26:13 CDT