imp时发生ora-01659的错误处理~!

今天从一个8i的库中导出一个大表,dump大约200M左右,然后导入9i的库,
结果报错:

import done in ZHS16GBK character set and UTF8 NCHAR character set
export server uses US7ASCII NCHAR character set (possible ncharset conversion)
. importing SMS's objects into LINKRICH_MMS
IMP-00017: following statement failed with ORACLE error 1659:
 "CREATE TABLE "T_MPN_OUTDATE" ("MOBILE" VARCHAR2(11), "HAPPEN_TIME" VARCHAR2"
 "(8), "PROV" VARCHAR2(5), "STATE" NUMBER)  PCTFREE 10 PCTUSED 40 INITRANS 1 "
 "MAXTRANS 255 LOGGING STORAGE(INITIAL 2147483646 NEXT 131072 MINEXTENTS 1 MA"
 "XEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL"
 " DEFAULT) TABLESPACE "USERS""
IMP-00003: ORACLE error 1659 encountered
ORA-01659: unable to allocate MINEXTENTS beyond 128 in tablespace USERS
Import terminated successfully with warnings.


仔细检查9i的users表空间,发现test表空间只有2G,并且不能自动扩展,于是扩大到3G,接着就能顺利
导入了,导入完毕后发现导入的表占用空间2.2G,原来imp工具导入前自动检测导入后所需空间和表空间
当前空间,若不足且不能自动扩展就报ORA-01659错误。

posted on 2010-09-09 16:46  ryan.ShowTime  阅读(2727)  评论(0编辑  收藏  举报

导航