What should be checked after an Oracle migration After a large data migration, what needs to be checked to be confident that the data move has succeeded?


the number of tables and rows in each schema is the same. 
the text data in the tables has not been corrupted. This is important if non alphanumeric characters (such as double byte) are used.
the dumps or other files that have been been transferred have the same checksum. 


Is there anything else that can be checked?
Are you trying to migrate the data between different versions of Oracle?


Generally, you can also look at your environmental parameter settings (init.ora parms) and your optimizer statistics after doing data migration.
See also Oracle tips for migration click here