Re: How can I find out differcences from two database?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 21 Dec 2005 06:59:34 -0800
Message-ID: <1135177174.818650.191270@g14g2000cwa.googlegroups.com>

Comparing rdbms dictionary DBA views will allow you to identify missing objects and like named objects with different structures.

You can start by just querying dba_objects and doing a count(*) with a group by on the owner, object_type to get a list. Removing the group by provides a full list of tables, indexes, views, package specifications and bodies, and a few more items.

You can then compare dba_tab_columns to find tables and views that differ in structure.

Do you also want to compare the data values? Do you want to compare the source line by line?

I believe that Tom Kyte has written on doing this and has posted table data compare code.

HTH -- Mark D Powell -- Received on Wed Dec 21 2005 - 08:59:34 CST