Re: Export from Solaris import to NT fails

A copy of this was sent to fresne_at_mindspring.com (if that email address didn't require changing) On Sun, 19 Sep 1999 11:00:02 -0500, you wrote:

>I have a couple of export files that were created on Oracle 8i under
>Solaris 2.6. When I try to Import them into an Oracle NT database the
>Imp program reports:
>

are you ftp'ing the dmp file?

if so -- did you forget "binary" in the ftp session before putting on NT? Else they will change CR's to CR/LF's

(is the dmp file on NT the same size as on Solaris would be a quick way to check)

>Connected to: Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production
>PL/SQL Release 8.0.5.0.0 - Production
>export file created by EXPORT:V08.01.05 via conventional path
>. importing SYSTEM's objects into ICC_STATE
>IMP-00008: unrecognized statement in the export file:
> #
>IMP-00008: unrecognized statement in the export file:
> 
>IMP-00008: unrecognized statement in the export file: ....
>
>I was thinking that maybe the RECORDLENGTH needs to be changed, but I'm
>not sure if it should be changed during the export, import, or both. If
>anyone has experience moving data from Solaris to NT please let me know
>what worked for you. Also, the export files are not corrupted (i.e. the
>import works fine going from Solaris to Solaris.)
>
>Thanks
>
>Ron Fresne

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Sun Sep 19 1999 - 10:58:44 CDT