tools or script to show data & structure difference between two databases

[robertbalmer]

I would use the MINUS operator.Write a procedure to get pk||' '||non-unique value of each row in each user_table. loop the return and put your result in a temp_table.



ouput should look like this:

select ic2.id||' '||ic2.table_name
from class@other_db ic2
minus
select ic.id||' '||ic.table_name
from class ic