Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: [IMP73] NT & UNIX
See man for "-a" switch in "zip" command!
-- Stjepan Brbot [Stjepan.Brbot_at_ZG.HiNet.HR] "Yann CAUCHARD" <yann.cauchard_at_spcconsultants.com> wrote in message news:9rbv1l$149u$1_at_news4.isdnet.net...Received on Fri Oct 26 2001 - 21:56:46 CDT
> 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
> >
> >
>
>
![]() |
![]() |