Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Import data problem
Dear all;
When I import the data, and I encounter the flowing error message, maybe you can help me to resolve this problem?
IMP-00017: following statement failed with ORACLE error 1630:
"ALTER TABLE "CLC" ADD CONSTRAINT "PK_CLC121_ARI_OTN_CSD" PRIMARY KEY
("CLC"
"_ARI","CLC_OTN","CLC_CSD") USING INDEX STORAGE (INITIAL 335687680 NEXT
1677"
"88544 MINEXTENTS 1 PCTINCREASE 50 FREELISTS 1 )
"
" "
IMP-00003: ORACLE error 1630 encountered
ORA-01630: max # extents (249) reached in temp segment in tablespace TEMP
Thanks alot
Johnson Hunag Received on Wed Jun 16 1999 - 23:23:01 CDT