Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: [IMP73] NT & UNIX

Re: [IMP73] NT & UNIX

From: Yann CAUCHARD <yann.cauchard_at_spcconsultants.com>
Date: Fri, 26 Oct 2001 17:23:12 +0200
Message-ID: <9rbv1l$149u$1@news4.isdnet.net>


I received the dmp file by mail, into a ZIP. So i think the dmp file is exactly the same that the one that was produced by UNIX.

I think the trouble is that unix EXP utility exports with chr(13)+chr(10), and that NT IMP utility imports with chr(10) only.

I think one solution is to convert chr(13)+chr(10) to chr(10) in the file, but there is perhaps a special parameter for IMP on NT to avoid this.

Yann

Norman Dunbar a écrit dans le message ...
>When you FTP'd the file from Unix to NT, did you do it in Binary mode ?
>If not, then every CHR(10) in the dump file will n ow be chr(13) +
>chr(10) [or is that chr(10) + chr(13) ] which will probably have
>affected the binary data in the dump file as well as the header stuff.
>I can import HPUX exports into an NT4 database with no problems.
>Try copying the file over again in Binary.
>
>Regards,
>Norman.
>
>------------------------------------------------------------------------
>-----
>Norman Dunbar EMail: Norman.Dunbar_at_LFS.co.uk
>Database/Unix administrator Phone: 0113 289 6265
> Fax: 0113 289 3146
>Lynx Financial Systems Ltd. URL: http://www.Lynx-FS.com
>------------------------------------------------------------------------
>-----
>
>
>-----Original Message-----
>From: Yann CAUCHARD [mailto:yann.cauchard_at_spcconsultants.com]
>Posted At: Friday, October 26, 2001 2:34 PM
>Posted To: server
>Conversation: [IMP73] NT & UNIX
>Subject: [IMP73] NT & UNIX
>
>
>Hi,
>
>I have a dump (exp73) of table from a 7.3.4 database runing under HP UX.
>
>I have to import this dump in a 7.3.4 running under NT.
>
>It seemes carriage return is different : chr(10) for NT &
>chr(13)+chr(10)
>for UX.
>
>IMP73 refuses to run, telling header verification failed.
>
>Is there a special parameter for IMP73 to succeed ?
>
>Thanks
>
>Yann
>
>
Received on Fri Oct 26 2001 - 10:23:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US