Has anyone had any luck with taking a backup (approx 30 tables) from an Oracle database's live environment, then loading a test environment with this backup and doing a comparison between the test environment and the backup taken from the live environment? Preferably without using queries against the live environment.
Note that the live environment will have transactions changing its data by the time the test environment is loaded, so I can't do a comparison using the live environment's data after loading the test environment.
The idea is to pick up any missing records, columns or even tables that the backup has missed. It would also be great to know if the actual data values were the same.
I'm thinking a hash function might be the best way to go. Are there any tools available for this?