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