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

On Thu, 28 Mar 2002 22:13:16 +0100, Frederic Payant <fpayant_at_club-internet.fr> wrote:

>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
>
>(c) Copyright 2000 Oracle Corporation. All rights reserved.
>
>
>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

First of all:
Thou shall *NEVER EVER MODIFY* the export file. It is not supported, and it is one of the safest ways to end up in hell or in your local employment office, whatever you prefer. Remove one byte from the export file inadvertently, and you have a fine chance *EVERYTHING* is *OUT OF SYNC*

Problems like the one you specify above (provided you did NOT EDIT the export file, otherwise you have to resolve it yourself) can be circumvented by specifying the buffer= keyword on the command line. Your IMP-0032 error message already points to that. 8192000 bytes (8M) is usually sufficient.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Mar 28 2002 - 17:21:47 CST