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.


1 Answer 1


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.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.