[8i][solaris 8] strange error during import

From: Frederic Payant <fpayant_at_club-internet.fr>
Date: Thu, 28 Mar 2002 22:13:16 +0100
Message-ID: <e117auodgoiht7pgkoh8ubnfq4pfqs5psc@4ax.com>

Hi,

Now that I know how to read and modify my exp file, I've another, very annoying problem :
I typed : imp system/manager full=yes indexfile=blabla and obtained the following error :

Import: Release 8.1.7.2.0 - Production on Je Mar 28 17:35:42 2002

Connected to: Oracle8i Enterprise Edition Release 8.1.7.2.0 -Production
With the Partitioning option
JServer Release 8.1.7.2.0 - Production

Export file created by EXPORT:V08.01.07 via conventional path import done in UTF8 character set and UTF8 NCHAR character set IMP-00032: SQL statement exceeded buffer length IMP-00008: unrecognized statement in the export file: GE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 20 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)), PARTITION "P_207851678114775040" VALUES LESS THAN (207851678114775040) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 81920 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "DATA_EMPTY_PINDB1" LOGGING LOB (BUFFER_BUF) STORE AS
(TABLESPACE "DATA_EMPTY_PINDB1" ENABLE STORAGE IN ROW CHUNK
8192 PCTVERSION 10 NOCACHE STORAGE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 20 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)), PARTITION "P_207869270300819456" VALUES LESS THAN
(207869270300819456) PCTFREE 10 PCTUSED 40 INITRANS 1
MAXTRANS 255 STORAGE(INITIAL 81920 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "DATA_EMPTY_PINDB1" LOGGING LSegmentation Fault(coredump)

I tried to modify some parameters of the export (NLS_LANG and so on) but always with the same result.

Both exp and imp are on the same environment - Solaris 8 and Oracle 8.1.7. with posix shell (/usr/xpg4/bin/sh) By the way I obtain the same result if I do the import on the same machine that is used for the export.

Is there any issue ?
Thanks to everybody

Amicalement
Frédéric PAYANT Received on Thu Mar 28 2002 - 15:13:16 CST