SQL Developer Data Modeler will do that. I posted a how-to on my blog today on
how to get your ALTER SCRIPTS with DROPs included.
For what it's worth, we don’t do DROP's out-of-the-box because...bad things
people do with tools w/o thinking.
Jeff
-----Original Message-----
From: Howard Latham [mailto:howard.latham@xxxxxxxxx]
Sent: Monday, October 19, 2015 11:22 AM
To: lkemnitz@xxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: compare schemas
Toad will do it.
On 19 October 2015 at 16:13, Leroy Kemnitz <lkemnitz@xxxxxxxx> wrote:
I am working in SQL developer 4.0. I am comparing my acceptance
version of a schema to my production version of the same schema. We
did some ‘clean-up’ of old tables and views in acceptance. We want to
apply the same changes to production, when we go to prod. How do I
tell SQL D to produce a ‘drop’ statement when running a diff and doing the
compare?
LeRoy
----------------------------------
LeRoy Kemnitz
Oracle Database Administrator
UW System Administration
Phone: (608) 265 -5775
Fax: (608) 265 - 2090