Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 1 down vote accepted

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

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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