Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Import data problem

Import data problem

From: Johnson Huang <johnson_at_infocomm.com.tw>
Date: Thu, 17 Jun 1999 12:23:01 +0800
Message-ID: <7k9t7k$iaa@netnews.hinet.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US