报错提示如下:
Import started on 2006-04-27 12:21:43
D:\oracle\ora90\bin\IMP.EXE log=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\plsimp.log file=F:\HISENS~1\qdhisense.dmp userid=system/manager@SIMON fromuser=qdhisense touser=snsoft buffer=30720 commit=yes grants=yes ignore=yes indexes=yes rows=yes show=no constraints=yes
连接到: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
With the Partitioning option
JServer Release 9.0.1.1.1 - Production
经由常规路径导出由EXPORT:V09.02.00创建的文件
已经完成ZHS16GBK字符集和AL16UTF16 NCHAR 字符集中的导入
. 正在将QDHISENSE的对象导入到 SNSOFT
IMP-00017: 由于 ORACLE 的 922 错误,以下的语句失败
"CREATE TABLE "ACCSTOCKDOWNP" ("MONTH" NUMBER(3, 0) NOT NULL ENABLE, "GCODE""
" VARCHAR2(20) NOT NULL ENABLE, "QTY" NUMBER(18, 4), "UNITTRUECOST" NUMBER(1"
"8, 4), "BALANCE" NUMBER(18, 4), "BALANCESTOCKDOWN" NUMBER(18, 4), "ACODE" V"
"ARCHAR2(16) NOT NULL ENABLE, "BQJT" NUMBER(18, 4), "BQZH" NUMBER(18, 4), "P"
"REDATE" DATE, "TRUEPRICE" NUMBER(18, 4), "VPREPARE" VARCHAR2(50), "BCODE" V"
"ARCHAR2(16), "IDX" NUMBER(20, 0) NOT NULL ENABLE, "VID" VARCHAR2(20), "BALA"
"NCE_CHECK" NUMBER(18, 4), "XCODE" VARCHAR2(35), "YEAR" VARCHAR2(4), "ICODE""
" VARCHAR2(16), "HCODE" VARCHAR2(16), "SCODE" VARCHAR2(16), "ODATE" DATE, "G"
"CODE_AGES" VARCHAR2(20)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STO"
"RAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "QDHISENSE" LO"
"GGING NOCOMPRESS"