Compare two databases and get the differences I want to between two databases and get the differences:


columns: in the first table the column name is varchar2(12), in the  second table the column name is varchar2(20). Or I have an
additional column in the first table.
data: I have to compare data between the same tables in different databases


I am aware of DBMS_COMPARISON, but need to do this on Oracle 10g.



Added after the answer by thatjeffsmith:

I know that SQL Developer can do that, but I have to develop a J2EE application which does that.
For item #1, you can use the Database Diff feature in SQL Developer - and yes, it should work on Oracle 10g.



This is a free feature in a no-cost tool provided by Oracle Corp.