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
Can I use /var/opt/oracle/oratab to specify listener information? Continue Reading
We would like to migrate our database from Oracle 8.1.7 to Oracle 10g. We would like to know the impact for our application developed using Delphi ... Continue Reading
I'm getting errors while installing the Database Configuration Assistant. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.