Q
Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

Tool to make sure Oracle database is consistent after migration

We are migrating from Oracle 9.2.0.6 on Windows to 9.2.0.6 on AIX 5.3. Is there any Oracle tool or script available to make sure that the database is consistent after migration?

We are migrating from Oracle 9.2.0.6 on Windows to 9.2.0.6 on AIX 5.3. Is there any Oracle tool or scripts available to make sure that the database is consistent after migration (i.e., it resembles the source database in size, number of objects, number of rows in each object, etc.)? Thanks in advance.
If you are using Oracle's export and import utilities to perform this migration, ensure that you create a log file for each export and import operation performed. This will provide you with object names and row counts, as well as any error messages, so that you have a basis for comparison after the migration. You can also write your own scripts and execute them via SQL*Plus to perform object and row counts. If you use a third-party GUI tool (such as DBArtisan or Toad with the DBA module), there may be an option to perform a schema compare between the two schemas (pre-migration and post-migration).

UPDATE: In the latest release of Select Journal from IOUG, there is an article titled "A DBA Foray into Open Source"...

written by Sean Hull. Sean does mention an open source product called Oracle Schemadiff which does allow two schemas to be compared. I have not tried the product, and Sean even mentions that the last time it was updated was at the end of 2002, so it may not work with Oracle 10g, but it might be worth a try. Oracle Schemadiff can be downloaded here.

This was last published in January 2007

Dig Deeper on Oracle database export, import and migration

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close