I want to between two databases and get the differences:
- columns: in the first table the column
name
isvarchar2(12)
, in the second table the columnname
isvarchar2(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.
Best Answer
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.