How to check if restored database is the same as original Is there a way to check if restored backup of Oracle database is the same as the original database? Is there a simple way to check it if I have the original database?
You can use SQL Developer, Tools - Database Diff, this would give you an idea. There is a tutorial here http://www.oracle.com/technetwork/issue-archive/2012/12-sep/o52sqldev-1735911.html. Only use the compare/diff section.