Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> cannot imp exp'd data?!?!?
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 Sun Jun 07 1998 - 09:46:17 CDT
![]() |
![]() |