IMP, extents error again!!(HELP!!!!!)

From: JK Yao <jkyf0131_at_hotmail.com>
Date: 31 Aug 2001 00:10:08 -0700
Message-ID: <93f65984.0108302310.7cb99274@posting.google.com>

dear all,

Following is the error msg for my import. There are about 12 millions rows, so the table is large. The table is about 2GB. Any suggestion for datafiles and tablespace or other setting for this table? And how to correct this problems and prevent it happen again?

Thanks a lot.

regards,
JK

---

IMP-00017: following statement failed with ORACLE error 1630:
"ALTER TABLE "PART_COST_BUCKET_HISTORY_TAB" ADD CONSTRAINT
"PART_COST_BUCKE"
"T_HISTORY_PK" PRIMARY KEY

("PART_NO","CONTRACT","HISTORY_SEQ_NO","COST_BUCK"
"ET_ID","TOP_LEVEL_PART_NO","BUCKET_LEVEL","BUCKET_SEQ") USING INDEX
PCTFREE"
" 10 INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 1254371328 NEXT 2097152
MINEXT"
"ENTS 1 PCTINCREASE 0 FREELISTS 1 ) TABLESPACE
"MPC_INDEX""
IMP-00003: ORACLE error 1630 encountered ORA-01630: max # extents (249) reached in temp segment in tablespace TEMP

---

Received on Fri Aug 31 2001 - 02:10:08 CDT