Re: Internal imp errors importing 8.1.7 dump file on 10.2

> I have a 24 GB dump file that was created with Oracle 8.1.7 on AIX,
> which I want to proof-read with 10.2 on Windows, so I did:
>
> imp system/xxx file=export.dmp fromuser=name touser=name show=y
>
> It runs fine for a while but then prints the following errors:
>
> illegal lob length marker 49408
> bytesread = 00000000000
> TABLE = MYTABLENAME
> IMP-00098: INTERNAL ERROR: impgst2
> IMP-00008: unrecognized statement in the export file:
> <07><1e>
> ...
> IMP-00032: SQL statement exceeded buffer length

The problem is solved, it wa a corruption issue after all (as most have guessed). The 24 GB dump file was on a Unix server which I accessed from a Windows PC via a Samba share. Samba and/or Windows obviously corrupted the file (damaging its contents while leaving the file size intact) when I computed the CRC as well as when I zipped and copied it, which is why I got identical CRCs before and after zipping/ copying/burning to CD/unzipping.

I copied the file again with ftp, and now it imports fine.

Thanks for all who helped.

Best regards
W. Rösler Received on Thu Jul 08 2010 - 07:31:43 CDT