Ask the Expert

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.

    Requires Free Membership to View

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 first published in August 2004

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: