How to verify database migration?
530421Aug 28 2006 — edited Aug 30 2006We are in the process of migrating a database from Oracle 9.2.0.1 on 32 bit Windows to 9.2.0.8 on 64 bit Linux. After using exp and imp to move a database between platforms and then running catpatch.sql to upgrade the freshly moved database, is there any way to verify that all that data has made it across and that the new database is working properly? Are there Oracle or third party tools that are designed to handle tasks like this? Is there anything in particular that we should be looking for between the two databases or in the log files?