Compare two databases and get the differences

oracleoracle-10g

I want to between two databases and get the differences:

  1. 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.
  2. 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.

Best Answer

For item #1, you can use the Database Diff feature in SQL Developer - and yes, it should work on Oracle 10g.

enter image description here

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