结果报错:[@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博客 ” ,链接:http://blog.itpub.net/3898/viewspace-787594/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/3898/viewspace-787594/