Re: Import problem

From: Andy Young <andy.young_at_12345pwgsc.gc.ca>
Date: Wed, 01 Dec 1999 14:18:19 -0500
Message-ID: <3845747B.DDD561C6@12345pwgsc.gc.ca>

I had the same thing yesterday. The .dmp file had an extra byte at the end of every line. This was probably caused by FTP adding a <CR> (x0d) . You can definitely import from 7.3 to 8.0, it is one of the recommended migration methods.

Oracle recommends that you redo the FTP using a binary transfer. I could not get another copy of the file.
I used Hexpert to convert every occurrence of x0a0d to x0a . It worked, but this is not recommended by Oracle.
http://www.psn.net/~mwoolsey/hexpert.html

+--------------------------+
| Andy Young               | The views expressed are my own and are not
|   Ottawa, Canada         |  those of PWGSC.
|  Public Works &          |

| Gov't Services Canada |

+--------------------------+

Rob van der Leer wrote:

> Hello,
> I've received a dump file which was made with Oracle 7.3.4.
> I want to import that file into Oracle 8.0.5.
> When I try to import, an error occurs.
>
> That error says that the header in the dmp file is incorrect (IMP-00010: not
> a valid importfile. Verification of header failed).
>
> I tried to import it into 7.3.3., but the same problem occurs.
>
> Is it possible to import from other versions than the one that you are
> running?
>
> TIA
>
> Rob van der Leer
> rleer_at_lnm.nl

-- Received on Wed Dec 01 1999 - 13:18:19 CST