Internal imp errors importing 8.1.7 dump file on 10.2

From: =?ISO-8859-1?Q?Wolfram_Rösler?= <wolfram.roesler_at_gmail.com> Newsgroups: comp.databases.oracle.server Subject: Internal imp errors importing 8.1.7 dump file on 10.2 Date: Mon, 5 Jul 2010 06:31:08 -0700 (PDT) Organization: http://groups.google.com
Lines: 37
Message-ID: <e08ad3b5-6bc8-4eb4-8103-e216a0b4fc14_at_d8g2000yqf.googlegroups.com> NNTP-Posting-Host: 87.139.81.19
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Trace: posting.google.com 1278336668 3307 127.0.0.1 (5 Jul 2010 13:31:08 GMT) X-Complaints-To: groups-abuse_at_google.com NNTP-Posting-Date: Mon, 5 Jul 2010 13:31:08 +0000 (UTC) Complaints-To: groups-abuse_at_google.com Injection-Info: d8g2000yqf.googlegroups.com; posting-host‡.139.81.19;

        posting-account 0PrgoAAABIEWBoqn39dxjbBBYQJvp0 User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1;

	Trident/4.0; GTB6.5; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 
	3.0.04506.648; .NET CLR 3.5.21022; MS-RTC LM 8; .NET CLR 3.0.4506.2152; .NET 
	CLR 3.5.30729),gzip(gfe)

Hello,

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

These occur several times until IMP-00008 repeats forever (until I aborted the import 16 hours later). Importing with a larger buffer ("buffer=2000000") made no difference.

The dump file can be imported without errors and warnings on the source machine (8.1.7 on AIX). The original dump file and my copy of it have identical CRCs so it's not a corruption issue. I'm running imp directly on the DB server so it's not a client/server compatibility issue either.

The export parameters are nothing special:

exp system/xxx file=export.dmp owner=name consistent=y

Any idea what's going wrong? Is the dump file ok, and if so, how can I import it?

Thanks for any help
W. Rösler Received on Mon Jul 05 2010 - 08:31:08 CDT