今天从一个8i的库中导出一个大表，dump大约200M左右，然后导入9i的库，
结果报错：[@more@]

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错误。

ITPub博客

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

最新文章