Q

Repairing a dump file

A database dump was exported from Oracle 8.1.7.3 on Solaris 5.8 using the following characterset setting for v$_nlsparameters
 NLS_NCHAR_CHARACTERSET      WE8MSWIN1252
This dump was transferred through FTP in binary mode and imported on Oracle 9.2 on Windows 2000 server. The following error was shown:
 ------------------------------------------------------------------
 Import: Release 9.2.0.1.0 - Production on Fri Jul 23 17:15:13 2004
 Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
  
 Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 -
 Production
 With the Partitioning, OLAP and Oracle Data Mining options
 JServer Release 9.2.0.1.0 - Production 
 Import file: EXPDAT.DMP > d:cp.dmp 
 Enter insert buffer size (minimum is 8192) 30720> 
 IMP-00010: not a valid export file, header failed verification
 IMP-00000: Import terminated unsuccessfully 
 --------------------------------------------------------------------
Is there any way by which I can repair the dump file? I found various tools on the Internet, like NXTract, but it failed. NXTsql only gives the table schema, but I also want the relationships and data.
I would redo the export. It is highly possible that the dump file is now corrupt, and I am not aware of any way to easily fix it. You can open the file with a binary editor and examine the contents, but this can be a very lengthy process. It is easier to redo the export.
This was last published in August 2004

Dig Deeper on Oracle database design and architecture

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

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close