Re: cannot imp exp'd data?!?!?

"GGING STORAGE(INITIAL 2147483646 NEXT 2548301824 MINEXTENTS 1 MAXEXTENTS 21"
 "47483645 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) "
 "TABLESPACE "DC4""
IMP-00003: ORACLE error 2219 encountered ORA-02219: invalid NEXT storage option value

The above statement requires 2.1 Gbytes of contiguous storage for the first extent
and 2.5 for the next (second, third, etc). You probably do not have that kind of
contiguous space.

You can create the table manually with more reasonable extents. Then import with the disregard table already created errors. The importer uses the
current table extents.

Mike K.

Thies C. Arntzen wrote:

> hi,
> just exported a 8.0.4 db, and now i'm trying to import it again (1st
> time i'm doing this, so please excuse me if i'm stupid;-)
>
> most tables import just fine but one "bigger" table doesn't:
>
> IMP-00017: following statement failed with ORACLE error 2219:
> "CREATE TABLE "DCSMAIN" ("DCSM_ID" NUMBER(*,0) NOT NULL ENABLE,
> "DCSM_POOL" "
> "VARCHAR2(16), "DCSM_MAINKEY" VARCHAR2(32), "DCSM_DATE" VARCHAR2(12),
> "DCSM_"
> "SOURCE" VARCHAR2(16), "DCSM_SOURCEXI" VARCHAR2(16), "DCSM_TYPE"
> VARCHAR2(32"
> "), "DCSM_RESSORT" VARCHAR2(32), "DCSM_RUBRIK" VARCHAR2(32),
> "DCSM_ISSUE" VA"
> "RCHAR2(8), "DCSM_PAGES" VARCHAR2(64), "DCSM_PAGCNT" NUMBER(*,0),
> "DCSM_DISC"
> "NT" NUMBER(*,0), "DCSM_PRTCNT" NUMBER(*,0), "DCSM_TITLE"
> VARCHAR2(255), "DC"
> "SM_TITLELO" VARCHAR2(255), "DCSM_MDFIVE" VARCHAR2(32), "DCSM_OCRFAIL"
> CHAR("
> "1), "DCSM_TEXT" LONG, "DCSM_MATCH" VARCHAR2(32), "DCSM_TSIZE"
> NUMBER(*,0), "
> ""DCSM_WORDS" NUMBER(*,0), "DCSM_LINES" NUMBER(*,0), "DCSM_PRIO"
> NUMBER(*,0)"
> ", "DCSM_SECT" VARCHAR2(32), "DCSM_TIME" VARCHAR2(12), "DCSM_PL_ID"
> NUMBER(*"
> ",0), "DCSM_FILSET" VARCHAR2(16), "DCSM_CREATION" VARCHAR2(16),
> "DCSM_DISABL"
> "ED" NUMBER(*,0), "DCSM_EDITSTA" VARCHAR2(16), "DCSM_EDITTIM" DATE,
> "DCSM_SI"
> "AM" NUMBER(*,0), "DCSM_GEGEN" VARCHAR2(32), "DCSM_CATEGORY"
> NUMBER(*,0), "D"
> "CSM_SPECIAL" NUMBER(*,0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS
> 255 LO"
> "GGING STORAGE(INITIAL 2147483646 NEXT 2548301824 MINEXTENTS 1
> MAXEXTENTS 21"
> "47483645 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL
> DEFAULT) "
> "TABLESPACE "DC4""
> IMP-00003: ORACLE error 2219 encountered
> ORA-02219: invalid NEXT storage option value
>
> hmm, does anybody know how i can reimport this table whitout editing the
> export file (1,6GB gzipped)....
>
> thanx,
> tc
Received on Mon Jun 08 1998 - 01:00:37 CDT