Database Comparison Script/Tool

From: Nancy Wells <nancy_b_wells_at_hotmail.com>
Date: 23 Nov 2002 21:46:20 -0800
Message-ID: <1f14c0b1.0211232146.f064cd8@posting.google.com>

Hi,

We are starting on the impact analysis of migrating custom code from an Oracle Apps 11.5.4 database to a 11.5.8 database.

Before we start we want to find out all the data model changes between the two databases. We want a list of all data objects (tables/synonyms etc) and views, that are unchanged between the two versions, a list of all new data objects + views, a list of all data objects that have been changed and the exact changes (column additions, deletions and column definition changes).

Is there a good tool available to do that? Does anyone have any scripts to do that?

Thanks in advance.

Regards,
N Wells Received on Sat Nov 23 2002 - 23:46:20 CST