Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2009
    Posts
    8

    Unanswered: IMP-00010 not a valid export file, header failed verification

    i have a dump file exported from 10.2 then i imported into 10.2 as well.
    All was doing fine for the exporting and importing.
    But when i use word pad to open the dump file and save it(i did not edit the file, i only open it and save it), the problem occur. IMP-00010 not a valid export file, header failed verification
    Any other way that i can edit the dump file without having this error?

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Quote Originally Posted by cheng99 View Post
    But when i use word pad to open the dump file and save it
    A dump file is a binary file. You cannot edit it with a text editor.

    Any other way that i can edit the dump file without having this error?
    Only by using a hex-editor.
    But editing the dump file is a very bad idea. Don't do it!

    What are you trying to do?

  3. #3
    Join Date
    Dec 2009
    Posts
    8
    Actually there i try to export from oracle 8.05 and want to import to oracle 10.2 as well.
    Some people suggested that i need pre-create the tablespace and user then i can import the dump file into 10.2.
    While studying the dump file, i realise that there was this temporart tablespace "TEMPORARY" in the oracle 8.05 exp dump file. But in 10.2, the temporary tablespace is named as "TEMP".
    An example:
    CREATE USER "J3AHE" IDENTIFIED BY VALUES 'HS8DJ3N394G40JF9' DEFAULT TBALESPACE "USR' TEMPORARY TABLESPACE "TEMPORARY"

    so i wanted to edit the name of temporary tablespace to "TEMP".

  4. #4
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool Echo...

    I hear a loud echo:

    Quote Originally Posted by shammat
    Editing the dump file is a very bad idea. Don't do it!
    Oracle dump files have checksums, therefore editing the file will cause corruption.

    Beter just add a small TEMPORARY tablespace and then you can remove it.

    You can find out the DDL contents of the dump file with this command:
    Code:
     imp userid/passwd show=y >ddl.txt
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •