NEXT statement in EXPORT file difffers from entry in USER

From: Kurt-Erich Finger <kurt-erich.finger_at_hte-company.de>
Date: 16 Dec 2002 02:43:53 -0800
Message-ID: <5208be2f.0212160243.67189883@posting.google.com>

ORACLE 8.1.7.3 on Win NT SP 4.0

Hello,

during an import I received the following error message with one table:

IMP-00058: ORACLE error 1631 encountered
ORA-01631: max # extents (1000) reached in table FAST.FOR_EVENTS
IMP-00018: partial import of previous table completed: 93558 rows

imported

This table was initially created with NEXT 10kb, however, I change the value to 10Mb. In USER_TABLES I find this value, in the ddl statements of theexport file this parameter contains the old value, 10kb, and then of course MAXEXTENTS of 1000 is too low. Why is the value in the export file different from the value I see in USER_TABLES?

2nd

I received the error:
IMP-00017: following statement failed with ORACLE error 1630:
"CREATE UNIQUE INDEX "EXPRES_PK" ON "FOR_EXP_RESULTS"
("EXP_RESULT_ID" ) PC"
"TFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 10240 NEXT 10240
MINEXTENT"
"S 1 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL "
"RECYCLE) TABLESPACE "FAST_EXP_IND_TS" LOGGING"
IMP-00003: ORACLE error 1630 encountered ORA-01630: max # extents (1000) reached in temp segment in tablespace FAST_EXP_IND_TS The tablespace was created by:
CREATE TABLESPACE "FAST_EXP_IND_TS" DATAFILE 'D:\oracleDBF\EXP_IND1.DBF' SIZE 100M

      AUTOEXTEND ON NEXT 10M  MAXSIZE 1200M 
      DEFAULT  STORAGE(INITIAL 10M
                       NEXT 10M
                       MINEXTENTS 1 
                       MAXEXTENTS 1000
                       PCTINCREASE 0) ONLINE PERMANENT;

ALTER TABLESPACE "FAST_EXP_IND_TS" ADD DATAFILE 'D:\oracleDBF\EXP_IND2.DBF' SIZE 100M

AUTOEXTEND ON NEXT 10M MAXSIZE 1200M ; The size of that tablespace is 1.4G. With the additional datafile there should be enough room. From this newsgroup I learned that maxextents should be set to UNLIMITED. Can I do this without running into another problem?

thanks,

Kurt-Erich Received on Mon Dec 16 2002 - 04:43:53 CST

NEXT statement in EXPORT file difffers from entry in USER_TABLES