How can I diff two Oracle 10g Schemas?

Solution 1:

The free and open-source SchemaCrawler tool that I wrote will do what you need. SchemaCrawler outputs details of your schema (tables, views, procedures, and more) in a diff-able plain-text format (text, CSV, or XHTML). SchemaCrawler can also output data (including CLOBs and BLOBs) in the same plain-text formats. You can use a standard diff program to diff the current output with a reference version of the output.

https://www.SchemaCrawler.com

You will need to provide a JDBC driver for your database.

Solution 2:

you don't need any of this stuff.

otn.oracle.com

Oracle has a free tool called SQL Developer. it has a schema diff.