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?

1 Answer 1


Are you trying to migrate the data between different versions of Oracle?

  1. Generally, you can also look at your environmental parameter settings (init.ora parms) and your optimizer statistics after doing data migration.

  2. See also Oracle tips for migration click here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.