I have two Oracle instances which need to be identical. One is built from an old base schema and a number of patch scripts. The other one is built from a new schema file which should be the same as the fully patched database.
Is there any way to easily compare two databases using something like db-unit? I will need to compare not only columns and data, but also stored procedures etc.