在import一个dmp文件的时候出错:出错信息如下
Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
With the Partitioning option
JServer Release 9.0.1.1.1 - Production
Export file created by EXPORT:V09.02.00 via conventional path
Warning: the objects were exported by K2DEV, not by you
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
export client uses WE8ISO8859P1 character set (possible charset conversion)
. importing K2DEV's objects into K2FMS
IMP-00017: following statement failed with ORACLE error 922:
"CREATE TABLE "K_ACCOUNT" ("ACCOUNT_NO" VARCHAR2(10) NOT NULL ENABL"
"E, "SERVICE_TYPE" VARCHAR2(3) NOT NULL ENABLE)PCTF"
"REE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1"
" FREELIST GROUPS 1) TABLESPACE "K2DEV" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
后来经人的指点,估计事import的版本跟export的版本不一致,import版本低了。从上面的日志文件大概可以看到export的版本是v09.02的,我应该怎么升级自己的数据库里的import也到这个版本呢?不会要重装数据库吧,请大侠救命啊