Re: Export from Solaris import to NT fails

From: Jan Nowitzky <nowitzky_at_informatik.uni-jena.de>
Date: Mon, 27 Sep 1999 20:42:31 +0200
Message-ID: <37EFBA97.84A48013@informatik.uni-jena.de>

I had the same problem.
NT - Oracle8i
DEC Unix - Oracle8.0.5

create an export on Oracle8i (NT) an then try an import (Unix)-> Error messages see below.
create an export on Oracle8.0.5 (Unix) an then try an import (NT) -> successfully

I transfer the data with ftp in binary mode.

What is the reason?
The documentation sad there are no problems on export/import between 8i an 8. Only if I use the new features (partitioning etc.), but I dont do so. I only want to export (and then import) a normal table.

Thanx for any help,
Jan

fresne_at_mindspring.com 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:
>
> 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

Jan Nowitzky
Friedrich-Schiller-Universität o Institut für Informatik

D-07740 Jena o Tel. +49/3641/9-46363 
E-Mail nowitzky_at_informatik.uni-jena.de
--------------------------------------------------------------

Received on Mon Sep 27 1999 - 13:42:31 CDT