Re: Oracle EXPORT/IMPORT

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1997/12/28
Message-ID: <34a6c04c.21856516@www.sigov.si>#1/1

On Sun, 28 Dec 1997 20:33:32 -0800, azaman <azaman_at_ibm.net> wrote:

>Hello Everyone
>
>I wonder if any of you can help me with the following problem:
>
>Scenario:
> an export of a table taken from an oracle 7.2 database
> running under HP-UNIX V10
>
> when trying to import this export file into an
> oracle 7.3 database under NT 4, I get the following
> message:
>
> ERROR: invalid export file; header verification failed.
>
>Notes:
> Having exported the file on the unix box, I ftped the file
> down onto a PC and the onto a floppy. Could any option in
> ftp be responsible for this ?
>

Since export's .dmp is binary file you must set ftp transfer mode to binary (usualy the mode defaults to ascii). In a ftp session use command "binary" prior to starting transfer (put/get).

>I would appreciate an e-mail .
>Arif Zaman ( azaman_at_ibm.net )

Regards,

---

Jurij Modic                             Republic of Slovenia
jurij.modic_at_mf.sigov.mail.si		Ministry of Finance
============================================================

The above opinions are mine and do not represent any official standpoints of my employer Received on Sun Dec 28 1997 - 00:00:00 CST