Compare two databases and get the differences
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.