Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to check data pump export dump integrity

778817Jun 11 2010 — edited Jun 18 2010

After using Oracle's data pump export (expdp) and creating a dump of a schema, is there any way to check this dump's integrity without importing it into a temporary schema? By integrity, I mean that when I import this dump in the future, I can be sure that it's exactly the same as when I exported it (ex. same no of tables, table structure, same data, no corrupted binary data). Is there such a way?

If none, what can be an efficient way to check integrity using a temporary schema? Run a schema compare?

Please advise.
Thanks!

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 15 2010

Added on Jun 11 2010

#database-key-features, #export-import-sql-loader-external-tables

9 comments

8,755 views