UPDATE: In the latest release of Select Journal from IOUG, there is an article titled "A DBA Foray into Open Source" written by Sean Hull. Sean does mention an open source product called Oracle Schemadiff which does allow two schemas to be compared. I have not tried the product, and Sean even mentions that the last time it was updated was at the end of 2002, so it may not work with Oracle 10g, but it might be worth a try. Oracle Schemadiff can be downloaded here.
Dig Deeper on Oracle database export, import and migration
Related Q&A from Maria Anderson
I'm getting errors while installing the Database Configuration Assistant. Continue Reading
I have been trying to install Oracle 8.1.7 on SUSE Linux 9.0 and got the error: "Error in invoking target install of makefile /opt/oracle/...../*.mk." Continue Reading
Can I use /var/opt/oracle/oratab to specify listener information? Continue Reading