Re: Using exp/imp file over different o/s

From: Leo Mannhart <mannhart_at_zuv.unizh.ch>
Date: Wed, 22 Jun 1994 07:42:03 GMT
Message-ID: <mannhart-220694084203_at_zuvmaclm.unizh.ch>


In article <1994Jun22.012245.8980_at_rossinc.com>, ronaldle_at_rossinc.com (Ronald F Leedy Jr) wrote:

> I have been trying to move an Oracle database from a VMS machine running 7.0.12
> to a HP-UX machine running 7.0.15 using the export/import facility. On the
> import, Oracle comes back with IMP-00009 abnormal end of export file. The error
> book says to report to Oracle with export file (and they might get back to me
> before Christmas).-(
>
> In thinking that it might be a problem with pulling the dmp file over the net
> via ftp I tried using different record lengths with no avail. Has anyone out
> there actually been successful porting a dmp?

Yes, I've done this a few times from IBM VM/CMS (EBCDIC) 6.0.30 via ftp to a sun (ASCII) 6.0.32 and 7.0.12 successfully. I used binary transfer mode
and Oracle is smart enough to convert from EBCDIC to ASCII. My first try was a success so may be your 7.0.15 installation is lacking some exp-views? (If Oracle can handle imp/exp form IBM host to Unix box (and vice versa) why
should it not from VMS to HP-UX (other than VMS likes Rdb) ;-)
>
> Thnaks in advance for any help passed my way.
>
>
> --
> =============================================================================
>
> Ronald Leedy Voice: (415) 593-2500 x2204
> Ross Systems Redwood City, CA ronaldle_at_rossinc.com
 

-- 
Leo Mannhart
Planning Office
University of Zurich               phone: ++41 1 257 23 34
Kuenstlergasse 15                    fax: ++41 1 257 22 12
CH-8001 Zurich, Switzerland        eMail: mannhart_at_zuv.unizh.ch
Received on Wed Jun 22 1994 - 09:42:03 CEST

Original text of this message