compare schemas
From: Leroy Kemnitz <lkemnitz_at_uwsa.edu>
Date: Mon, 19 Oct 2015 15:13:52 +0000
Message-ID: <BN3PR0701MB16378BFF334E74879DE3E666B63A0_at_BN3PR0701MB1637.namprd07.prod.outlook.com>
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 Kemnitz
Oracle Database Administrator
UW System Administration
Phone: (608) 265 -5775
Fax: (608) 265 - 2090
Date: Mon, 19 Oct 2015 15:13:52 +0000
Message-ID: <BN3PR0701MB16378BFF334E74879DE3E666B63A0_at_BN3PR0701MB1637.namprd07.prod.outlook.com>
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
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 19 2015 - 17:13:52 CEST