Re: Import data problem

Hi,

You need either to change the default storage clause of the tablespace TEMP to make sure the temporary segment gets bigger extents and hence less in number, or you need to change maxextents of that tablespace. I would probably use the first solution.

Hth,

Sybrand Bakker, Oracle DBA

Johnson Huang wrote in message <7k9t7k$iaa_at_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:34:25 CDT