Re: Comparing Objects

If you just want to know if the same objects are in each of the instances

create a database link to prod
select object_name,object_type from all_objects where owner='X' minus
select object_name,object_type from all_objects_at_prod where owner='X';

Then do
select object_name,object_type from all_objects_at_prod where owner='X' minus
select object_name,object_type from all_objects where owner='X';

This won't tell you if a package,procedure, function is the correct version or if the columns in a table or view are all the same. That would require a bit more work. There are a number of software packages from Oracle and other vendors that compare database objects but I haven't used any of them.

Mike

Mark G wrote:
>
> Does anyone have any good methods of comparing the objects in one
> development database to those of a production database? Software, scripts,
> etc.
>
> I want to ensure that the databases are 'synchronized' from an object point
> of view (not data).
>
> TIA
Received on Tue Aug 15 2000 - 21:02:39 CDT