小机上oracle9i的数据导出后,imp导入win2003操作系统oracle9i会报错不知为什么??? 谢谢??? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 好。都是9i但不知道oracle9i的9.0.1.1.1版本号不同会有影响吗。 IMP-00003: 遇到 ORACLE 错误 922ORA-00922: 缺少或无效选项IMP-00017: 由于 ORACLE 的 922 错误,以下的语句失败 "CREATE TABLE "AR_TEMPPLATE" ("PM" VARCHAR2(15) NOT NULL ENABLE, "DJRQ" D" "ATE NOT NULL ENABLE, "QLX" CHAR(1) NOT NULL ENABLE, "SYR" VARCHAR2(128) NO" "T NULL ENABLE, "SFZM" VARCHAR2(18), "CLP" VARCHAR2(32) NOT NULL ENABLE," " "LXH" VARCHAR2(32) NOT NULL ENABLE, "LLX" CHAR(3) NOT NULL ENABLE, "JH" "" VARCHAR2(32) NOT NULL ENABLE, "CLSBDH" VARCHAR2(25) NOT NULL ENABLE, "HDZ" "ZL" NUMBER(8, 0), "HK" NUMBER(3, 0), "XD" VARCHAR2(50), "XSD" VARCHAR2" "(50), "YQ" NUMBER(2, 0) NOT NULL ENABLE, "XH" CHAR(14), "JBR" VARCHAR2(30)" ", "ZJG" VARCHAR2(10) NOT NULL ENABLE, "LH" CHAR(11), "BZ" VARCHAR2(128), " ""XDZ" VARCHAR2(128), "BM" CHAR(6), "LH" VARCHAR2(20), "BGS" VARCHAR2(" "64), "SXRQ" DATE, "ZQ" DATE, "PZH" VARCHAR2(64), "SC" CHAR(1), "XT" "JD" VARCHAR2(50), "YXQZ" DATE, "GLBM" VARCHAR2(10), "LXLH" VARCHAR2(20), " ""HLX" CHAR(1), "YZL" CHAR(2), "YM" VARCHAR2(15), "HH" VARCHAR2(20)" ", "JKPZ" CHAR(1), "JKPH" VARCHAR2(20)) PCTFREE 10 PCTUSED 40 INITRANS 1 " "MAXTRANS 255 STORAGE(INITIAL 655360 FREELISTS 1 FREELIST GROUPS 1) TABLESPA" "CE "AR_DATA" LOGGING NOCOMPRESS"IMP-00003: 遇到 ORACLE 错误 922ORA-00922: 缺少或无效选项IMP-00017: 由于 ORACLE 的 922 错误,以下的语句失败 "CREATE TABLE "AR_USE_OLDNO" ("LH" CHAR(11) NOT NULL ENABLE, "HPZL" CHAR(2" ") NOT NULL ENABLE, "PM" VARCHAR2(15) NOT NULL ENABLE, "GLBM" VARCHAR2(10)" " NOT NULL ENABLE, "SY" DATE NOT NULL ENABLE, "JBR" VARCHAR2(30)) PCTFREE" " 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 16384 FREELISTS 1 FR" "EELIST GROUPS 1) TABLESPACE "AR_DATA" LOGGING NOCOMPRESS"IMP-00003: 遇到 ORACLE 错误 922ORA-00922: 缺少或无效选项IMP-00017: 由于 ORACLE 的 922 错误,以下的语句失败 "CREATE TABLE "AR_VALIDATE" ("LH" VARCHAR2(11) NOT NULL ENABLE, "HPZL" CHA" "R(2), "PM" VARCHAR2(15), "HM" CHAR(1) NOT NULL ENABLE, "BZ" VARCHAR2(10" ")) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 81920 FRE" "ELISTS 1 FREELIST GROUPS 1) TABLESPACE "AR_DATA" LOGGING NOCOMPRESS"IMP-00003: 遇到 ORACLE 错误 922ORA-00922: 缺少或无效选项IMP-00017: 由于 ORACLE 的 922 错误,以下的语句失败 "CREATE TABLE "AR_VALIDATEITEM" ("HM" CHAR(1) NOT NULL ENABLE, "YWLX" CHA" "R(1) NOT NULL ENABLE, "YdWYY" CHAR(1) NOT NULL ENABLE, "HCKGW" CHAR(1) NOT NU" "LL ENABLE, "TSTGXX" VARCHAR2(64) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INIT" "RANS 1 MAXTRANS 255 STORAGE(INITIAL 81920 FREELISTS 1 FREELIST GROUPS 1) TA" "BLESPACE "AR_DATA" LOGGING NOCOMPRESS"IMP-00003: 遇到 ORACLE 错误 922ORA-00922: 缺少或无效选项IMP-00017: 由于 ORACLE 的 922 错误,以下的语句失败 "CREATE TABLE "AR_YWJDJGB" ("JDSJ" DATE NOT NULL ENABLE, "QSRQ" VARCHAR2(10" ") NOT NULL ENABLE, "JSGGRQ" VARCHAR2(10) NOT NULL ENABLE, "XZFQH" VARCHAR2(10)" " NOT NULL ENABLE, "YWGFLX" VARCHAR2(10) NOT NULL ENABLE, "YWGSL" NUMBER, "YWBL" "" NUMBER(4, 2)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INIT" "IAL 81920 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "AR_DATA" LOGGING NOCO" "MPRESS"IMP-00003: 遇到 ORACLE 错误 922ORA-00922: 缺少或无效选项IMP-00017: 由于 ORACLE 的 922 错误,以下的语句失败 "CREATE TABLE "AR_YWJDSZB" ("XZQH" VARCHAR2(10) NOT NULL ENABLE, "XSMC" VAR" "CHAR2(20) NOT NULL ENABLE, "SJKLJM" VARCHAR2(100), "GLBMQ" VARCHAR2(10) NOT" " NULL ENABLE, "GLBMZ" VARCHAR2(10) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 " "INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 81920 FREELISTS 1 FREELIST GROUPS 1" ") TABLESPACE "AR_DATA" LOGGING NOCOMPRESS"IMP-00003: 遇到 ORACLE 错误 922ORA-00922: 缺少或无效选项IMP-00017: 由于 ORACLE 的 922 错误,以下的语句失败 "CREATE TABLE "AR_ZZXH_HD" ("GLBM" VARCHAR2(12) NOT NULL ENABLE, "XZQH" VAR" "CHAR2(12) NOT NULL ENABLE, "HPZL" CHAR(2) NOT NULL ENABLE, "HD" VARCHAR2(25" "6) NOT NULL ENABLE, "JZHP" VARCHAR2(1024), "ZT" CHAR(1) NOT NULL ENABLE, "D" "ABHT" VARCHAR2(12) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTR" "ANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "VE" "H_USER" LOGGING NOCOMPRESS"IMP-00003: 遇到 ORACLE 错误 922ORA-00922: 缺少或无效选项IMP-00017: 由于 ORACLE 的 922 错误,以下的语句失败 "CREATE TABLE "AR_ZZXH_HDTJ" ("HD" VARCHAR2(10) NOT NULL ENABLE, "ZSL" NUMB" "ER, "YFSL" NUMBER, "TJSJ" DATE, "GLBM" VARCHAR2(12), "HPZL" CHAR(2) NOT NUL" 续 "L ENABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65" "536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "AR_USER" LOGGING NOCOMPRESS"IMP-00003: 遇到 ORACLE 错误 922ORA-00922: 缺少或无效选项IMP-00017: 由于 ORACLE 的 922 错误,以下的语句失败 "CREATE TABLE "AR_ZZXH_LOG" ("HPZL" VARCHAR2(2) NOT NULL ENABLE, "PM" VAR" "CHAR2(15) NOT NULL ENABLE, "XHSJ" DATE NOT NULL ENABLE, "GLBM" VARCHAR2(10)" " NOT NULL ENABLE, "LH" VARCHAR2(20) NOT NULL ENABLE, "JBR" VARCHAR2(50) NO" "T NULL ENABLE, "IP" VARCHAR2(20)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRAN" "S 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "AR_" "USER" LOGGING NOCOMPRESS"IMP-00003: 遇到 ORACLE 错误 922ORA-00922: 缺少或无效选项IMP-00017: 由于 ORACLE 的 922 错误,以下的语句失败 "CREATE TABLE "AR_ZZXH_PARAM" ("GLBM" VARCHAR2(20) NOT NULL ENABLE, "SWKSSJ" "" VARCHAR2(10) NOT NULL ENABLE, "SWJSSJ" VARCHAR2(10) NOT NULL ENABLE, "XWK" "SSJ" VARCHAR2(10) NOT NULL ENABLE, "XWJSSJ" VARCHAR2(10) NOT NULL ENABLE, "" "XHGZ" BLOB) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL " "65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "AR_USER" LOGGING NOCOMPRE" "SS LOB ("XHGZ") STORE AS (TABLESPACE "AR_USER" ENABLE STORAGE IN ROW CHUN" "K 8192 PCTVERSION 10 NOCACHE STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GR" "OUPS 1))"IMP-00003: 遇到 ORACLE 错误 922ORA-00922: 缺少或无效选项IMP-00017: 由于 ORACLE 的 922 错误,以下的语句失败 "CREATE TABLE "VIO_CANCEL" ("CXJDSH" VARCHAR2(10) NOT NULL ENABLE, "JDJG" VA" "RCHAR2(10) NOT NULL ENABLE, "DSR" VARCHAR2(30), "ZSXZQH" VARCHAR2(10), "ZSX" "XDZ" VARCHAR2(128), "CXXM" VARCHAR2(2) NOT NULL ENABLE, "JSZH" VARCHAR2(18)" " NOT NULL ENABLE, "DABH" VARCHAR2(12) NOT NULL ENABLE, "FZJG" VARCHAR2(10)," " "CPZL" VARCHAR2(2), "CPHM" VARCHAR2(15), "JDCSYR" VARCHAR2(128), "WFXW" VA" "RCHAR2(4) NOT NULL ENABLE, "CXRQ" DATE NOT NULL ENABLE, "ZDBJ" VARCHAR2(1) " "NOT NULL ENABLE, "JLLX" VARCHAR2(1) NOT NULL ENABLE, "GXSJ" DATE NOT NULL E" "NABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 81920" " FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "AR_USER" LOGGING NOCOMPRESS"IMP-00003: 遇到 ORACLE 错误 922ORA-00922: 缺少或无效选项IMP-00017: 由于 ORACLE 的 922 错误,以下的语句失败 "CREATE TABLE "VIO_FORCE" ("PZBH" VARCHAR2(10) NOT NULL ENABLE, "XM" VARCHAR" "2(30) NOT NULL ENABLE, "ZSXZQH" VARCHAR2(10), "ZSXXDZ" VARCHAR2(128), "TEL"" " VARCHAR2(50), "LXFS" VARCHAR2(128), "SYR" VARCHAR2(50), "JSZH" VARCHAR2(18" "), "DABH" VARCHAR2(12) NOT NULL ENABLE, "FZJG" VARCHAR2(10) NOT NULL ENABLE" ", "HPZL" VARCHAR2(2), "PM" VARCHAR2(15), "JTFS" VARCHAR2(2) NOT NULL ENAB" "LE, "WZSJ" DATE NOT NULL ENABLE, "WZXW1" VARCHAR2(4) NOT NULL ENABLE, "WZXW" "2" VARCHAR2(4), "WZXW3" VARCHAR2(4), "WZXW4" VARCHAR2(4), "WZXW5" VARCHAR2(" "4), "WZDD" VARCHAR2(12) NOT NULL ENABLE, "QZCSXM" VARCHAR2(1) NOT NULL ENAB" "LE, "KLQX" NUMBER(3, 0), "JSJQBJ" VARCHAR2(2), "ZQMJ" VARCHAR2(30) NOT NULL" " ENABLE, "FXJG" VARCHAR2(10) NOT NULL ENABLE, "CJSJ" DATE, "JDSBH" VARCHAR2" "(10), "CJBJ" VARCHAR2(1), "ZDBJ" VARCHAR2(1), "GXSJ" DATE, "DKBJ" VARCHAR2(" "1), "BZ" VARCHAR2(100), "LRR" VARCHAR2(30)) PCTFREE 10 PCTUSED 40 INITRANS" " 1 MAXTRANS 255 STORAGE(INITIAL 81920 FREELISTS 1 FREELIST GROUPS 1) TABLES" "PACE "AR_DATA" LOGGING NOCOMPRESS"IMP-00003: 遇到 ORACLE 错误 922ORA-00922: 缺少或无效选项IMP-00017: 由于 ORACLE 的 922 错误,以下的语句失败 "CREATE TABLE "VIO_VIOLATION" ("WZBH" VARCHAR2(22) NOT NULL ENABLE, "JDSLB" " "VARCHAR2(1) NOT NULL ENABLE, "DABH" VARCHAR2(12), "JDSBH" VARCHAR2(10) NOT " "NULL ENABLE, "JSZH" VARCHAR2(18), "ZJLX" VARCHAR2(1), "FZJG" VARCHAR2(10), " ""XM" VARCHAR2(30), "XB" VARCHAR2(1), "NL" VARCHAR2(10), "ZJCX" VARCHAR2(30)" ", "ZSXZQH" VARCHAR2(10), "ZSXXDZ" VARCHAR2(128), "SYR" VARCHAR2(50), "HPZL"" " VARCHAR2(2), "PM" VARCHAR2(15), "JTFS" VARCHAR2(2) NOT NULL ENABLE, "WZS" "J" DATE NOT NULL ENABLE, "WZDD" CHAR(12) NOT NULL ENABLE, "WZXW" CHAR(4) NO" "T NULL ENABLE, "ZQMJ" VARCHAR2(30) NOT NULL ENABLE, "ZQMJ2" VARCHAR2(30), "" "WZJFS" NUMBER(2, 0), "FKJE" NUMBER(6, 2), "ZNJ" NUMBER(6, 2), "JKFS" VARCHA" "R2(1), "CLJG" VARCHAR2(10) NOT NULL ENABLE, "CFJG" VARCHAR2(4) NOT NULL ENA" "BLE, "CLSJ" DATE, "CLBJ" VARCHAR2(1) NOT NULL ENABLE, "ZDBJ" VARCHAR2(1), "" "GXSJ" DATE, "DKBJ" VARCHAR2(1), "TEL" VARCHAR2(50), "LXFS" VARCHAR2(128), "" "FXJG" VARCHAR2(10) NOT NULL ENABLE, "JSJQBJ" VARCHAR2(2), "LRR" VARCHAR2(50" ") NOT NULL ENABLE, "BZ" VARCHAR2(128), "JBR1" VARCHAR2(30), "JBR2" VARCHAR2" "(30)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 81920 " "FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "AR_DATA" LOGGING NOCOMPRESS"IMP-00003: 遇到 ORACLE 错误 922ORA-00922: 缺少或无效选项IMP-00041: 警告: 创建的对象带有编译警告 "CREATE FORCE VIEW "AR_ADMIN"."AR_FLOW_V" ("LH","XH" "","YWLX","YWYY","SYR","HPZL","PM","CLPP1","CLXH","CLLX","XZQH","SQRQ","BJ" "RQ","XYGW","YWLC","LSZT","GLBM","FPBJ","FFBJ","RKBJ","CLSBDH") AS " "Select LH, Xh, Ywlx, Ywyy, Syr, Hpzl, PM, Clpp1, Clxh, Cllx, Xzqh," " Sqrq, Bjrq, Xygw, Ywlc, Lszt, Glbm, Fpbj, Ffbj, Rkbj, Clsbdh" " From AR_Flow" " Union All" " Select LH, Xh, Ywlx, Ywyy, Syr, Hpzl, PM, Clpp1, Clxh, Cllx, Xzqh," " Sqrq, Bjrq, Xygw, Ywlc, Lszt, Glbm, Fpbj, Ffbj, Rkbj, Clsbdh" " From AR_Flow_His"IMP-00041: 警告: 创建的对象带有编译警告 "CREATE FORCE VIEW "AR_ADMIN"."AR_LOG_V" ("LH","CLR" "Q","YWLX","YWYY","HPZL","PM","XH","YWGW","CZGW","JBR","GLBM","BZ") AS " "Select LH, Clrq, Ywlx, Ywyy, Hpzl, PM, Xh, Ywgw, Czgw, Jbr, Glbm, Bz" " From AR_Log" " Union All" " Select LH, Clrq, Ywlx, Ywyy, Hpzl, PM, Xh, Ywgw, Czgw, Jbr, Glbm, Bz" " From AR_Log_His"IMP-00017: 由于 ORACLE 的 2248 错误,以下的语句失败 "ALTER SESSION SET "_LOAD_WITHOUT_COMPILE" = PLSQL"IMP-00003: 遇到 ORACLE 错误 2248ORA-02248: 无效的 ALTER SESSION 选项IMP-00017: 由于 ORACLE 的 1917 错误,以下的语句失败 "GRANT EXECUTE ON "AR_INTERFACE" TO "HPZY""IMP-00003: 遇到 ORACLE 错误 1917ORA-01917: 用户或作用'HPZY'不存在IMP-00017: 由于 ORACLE 的 2248 错误,以下的语句失败 "ALTER SESSION SET "_LOAD_WITHOUT_COMPILE" = NONE"IMP-00003: 遇到 ORACLE 错误 2248ORA-02248: 无效的 ALTER SESSION 选项IMP-00017: 由于 ORACLE 的 901 错误,以下的语句失败 "CREATE FORMAT92TRIG "IMP-00003: 遇到 ORACLE 错误 901ORA-00901: 无效 CREATE 命令 IMP-00008: 导出文件中出现无法识别的语句:IMP-00008: 导出文件中出现无法识别的语句:IMP-00017: 由于 ORACLE 的 901 错误,以下的语句失败 "CREATE FORMAT92TRIG "IMP-00003: 遇到 ORACLE 错误 901ORA-00901: 无效 CREATE 命令IMP-00008: 导出文件中出现无法识别的语句:?(IMP-00008: 导出文件中出现无法识别的语句:IMP-00009: 导出文件异常结束成功终止导入,但出现警告。 用不同的版本号EXP导出的文件,是不能完全兼容的IMP导回到10G的,你可以去网上查下相关的兼容性问题的解决文章 Oracle导入dmp文件后,出现很多包头、包体编译错误怎么解决? 关于oracle数据抽取的问题 安装ORACLE9i 没反应 用sqlplus登录oracle失败应该如何解决? 系统导出到Excel中文乱码 空字符串就是null吗 怎么实现如下SQL语句 请高手告诉我怎么能通过身份证计算出到现在的年龄 怎样买oracle?配置plsql网络应用程序要用9iAS和db,怎样购买license?cpu和named user怎么算? 表的列名和关键字冲突了 ORACLE连接问题 写trigger的时候总是这条错误
ORA-00922: 缺少或无效选项
IMP-00017: 由于 ORACLE 的 922 错误,以下的语句失败
"CREATE TABLE "AR_TEMPPLATE" ("PM" VARCHAR2(15) NOT NULL ENABLE, "DJRQ" D"
"ATE NOT NULL ENABLE, "QLX" CHAR(1) NOT NULL ENABLE, "SYR" VARCHAR2(128) NO"
"T NULL ENABLE, "SFZM" VARCHAR2(18), "CLP" VARCHAR2(32) NOT NULL ENABLE,"
" "LXH" VARCHAR2(32) NOT NULL ENABLE, "LLX" CHAR(3) NOT NULL ENABLE, "JH"
"" VARCHAR2(32) NOT NULL ENABLE, "CLSBDH" VARCHAR2(25) NOT NULL ENABLE, "HDZ"
"ZL" NUMBER(8, 0), "HK" NUMBER(3, 0), "XD" VARCHAR2(50), "XSD" VARCHAR2"
"(50), "YQ" NUMBER(2, 0) NOT NULL ENABLE, "XH" CHAR(14), "JBR" VARCHAR2(30)"
", "ZJG" VARCHAR2(10) NOT NULL ENABLE, "LH" CHAR(11), "BZ" VARCHAR2(128), "
""XDZ" VARCHAR2(128), "BM" CHAR(6), "LH" VARCHAR2(20), "BGS" VARCHAR2("
"64), "SXRQ" DATE, "ZQ" DATE, "PZH" VARCHAR2(64), "SC" CHAR(1), "XT"
"JD" VARCHAR2(50), "YXQZ" DATE, "GLBM" VARCHAR2(10), "LXLH" VARCHAR2(20), "
""HLX" CHAR(1), "YZL" CHAR(2), "YM" VARCHAR2(15), "HH" VARCHAR2(20)"
", "JKPZ" CHAR(1), "JKPH" VARCHAR2(20)) PCTFREE 10 PCTUSED 40 INITRANS 1 "
"MAXTRANS 255 STORAGE(INITIAL 655360 FREELISTS 1 FREELIST GROUPS 1) TABLESPA"
"CE "AR_DATA" LOGGING NOCOMPRESS"
IMP-00003: 遇到 ORACLE 错误 922
ORA-00922: 缺少或无效选项
IMP-00017: 由于 ORACLE 的 922 错误,以下的语句失败
"CREATE TABLE "AR_USE_OLDNO" ("LH" CHAR(11) NOT NULL ENABLE, "HPZL" CHAR(2"
") NOT NULL ENABLE, "PM" VARCHAR2(15) NOT NULL ENABLE, "GLBM" VARCHAR2(10)"
" NOT NULL ENABLE, "SY" DATE NOT NULL ENABLE, "JBR" VARCHAR2(30)) PCTFREE"
" 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 16384 FREELISTS 1 FR"
"EELIST GROUPS 1) TABLESPACE "AR_DATA" LOGGING NOCOMPRESS"
IMP-00003: 遇到 ORACLE 错误 922
ORA-00922: 缺少或无效选项
IMP-00017: 由于 ORACLE 的 922 错误,以下的语句失败
"CREATE TABLE "AR_VALIDATE" ("LH" VARCHAR2(11) NOT NULL ENABLE, "HPZL" CHA"
"R(2), "PM" VARCHAR2(15), "HM" CHAR(1) NOT NULL ENABLE, "BZ" VARCHAR2(10"
")) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 81920 FRE"
"ELISTS 1 FREELIST GROUPS 1) TABLESPACE "AR_DATA" LOGGING NOCOMPRESS"
IMP-00003: 遇到 ORACLE 错误 922
ORA-00922: 缺少或无效选项
IMP-00017: 由于 ORACLE 的 922 错误,以下的语句失败
"CREATE TABLE "AR_VALIDATEITEM" ("HM" CHAR(1) NOT NULL ENABLE, "YWLX" CHA"
"R(1) NOT NULL ENABLE, "YdWYY" CHAR(1) NOT NULL ENABLE, "HCKGW" CHAR(1) NOT NU"
"LL ENABLE, "TSTGXX" VARCHAR2(64) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INIT"
"RANS 1 MAXTRANS 255 STORAGE(INITIAL 81920 FREELISTS 1 FREELIST GROUPS 1) TA"
"BLESPACE "AR_DATA" LOGGING NOCOMPRESS"
IMP-00003: 遇到 ORACLE 错误 922
ORA-00922: 缺少或无效选项
IMP-00017: 由于 ORACLE 的 922 错误,以下的语句失败
"CREATE TABLE "AR_YWJDJGB" ("JDSJ" DATE NOT NULL ENABLE, "QSRQ" VARCHAR2(10"
") NOT NULL ENABLE, "JSGGRQ" VARCHAR2(10) NOT NULL ENABLE, "XZFQH" VARCHAR2(10)"
" NOT NULL ENABLE, "YWGFLX" VARCHAR2(10) NOT NULL ENABLE, "YWGSL" NUMBER, "YWBL"
"" NUMBER(4, 2)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INIT"
"IAL 81920 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "AR_DATA" LOGGING NOCO"
"MPRESS"
IMP-00003: 遇到 ORACLE 错误 922
ORA-00922: 缺少或无效选项
IMP-00017: 由于 ORACLE 的 922 错误,以下的语句失败
"CREATE TABLE "AR_YWJDSZB" ("XZQH" VARCHAR2(10) NOT NULL ENABLE, "XSMC" VAR"
"CHAR2(20) NOT NULL ENABLE, "SJKLJM" VARCHAR2(100), "GLBMQ" VARCHAR2(10) NOT"
" NULL ENABLE, "GLBMZ" VARCHAR2(10) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 "
"INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 81920 FREELISTS 1 FREELIST GROUPS 1"
") TABLESPACE "AR_DATA" LOGGING NOCOMPRESS"
IMP-00003: 遇到 ORACLE 错误 922
ORA-00922: 缺少或无效选项
IMP-00017: 由于 ORACLE 的 922 错误,以下的语句失败
"CREATE TABLE "AR_ZZXH_HD" ("GLBM" VARCHAR2(12) NOT NULL ENABLE, "XZQH" VAR"
"CHAR2(12) NOT NULL ENABLE, "HPZL" CHAR(2) NOT NULL ENABLE, "HD" VARCHAR2(25"
"6) NOT NULL ENABLE, "JZHP" VARCHAR2(1024), "ZT" CHAR(1) NOT NULL ENABLE, "D"
"ABHT" VARCHAR2(12) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTR"
"ANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "VE"
"H_USER" LOGGING NOCOMPRESS"
IMP-00003: 遇到 ORACLE 错误 922
ORA-00922: 缺少或无效选项
IMP-00017: 由于 ORACLE 的 922 错误,以下的语句失败
"CREATE TABLE "AR_ZZXH_HDTJ" ("HD" VARCHAR2(10) NOT NULL ENABLE, "ZSL" NUMB"
"ER, "YFSL" NUMBER, "TJSJ" DATE, "GLBM" VARCHAR2(12), "HPZL" CHAR(2) NOT NUL"
"L ENABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65"
"536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "AR_USER" LOGGING NOCOMPRESS"
IMP-00003: 遇到 ORACLE 错误 922
ORA-00922: 缺少或无效选项
IMP-00017: 由于 ORACLE 的 922 错误,以下的语句失败
"CREATE TABLE "AR_ZZXH_LOG" ("HPZL" VARCHAR2(2) NOT NULL ENABLE, "PM" VAR"
"CHAR2(15) NOT NULL ENABLE, "XHSJ" DATE NOT NULL ENABLE, "GLBM" VARCHAR2(10)"
" NOT NULL ENABLE, "LH" VARCHAR2(20) NOT NULL ENABLE, "JBR" VARCHAR2(50) NO"
"T NULL ENABLE, "IP" VARCHAR2(20)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRAN"
"S 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "AR_"
"USER" LOGGING NOCOMPRESS"
IMP-00003: 遇到 ORACLE 错误 922
ORA-00922: 缺少或无效选项
IMP-00017: 由于 ORACLE 的 922 错误,以下的语句失败
"CREATE TABLE "AR_ZZXH_PARAM" ("GLBM" VARCHAR2(20) NOT NULL ENABLE, "SWKSSJ"
"" VARCHAR2(10) NOT NULL ENABLE, "SWJSSJ" VARCHAR2(10) NOT NULL ENABLE, "XWK"
"SSJ" VARCHAR2(10) NOT NULL ENABLE, "XWJSSJ" VARCHAR2(10) NOT NULL ENABLE, ""
"XHGZ" BLOB) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL "
"65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "AR_USER" LOGGING NOCOMPRE"
"SS LOB ("XHGZ") STORE AS (TABLESPACE "AR_USER" ENABLE STORAGE IN ROW CHUN"
"K 8192 PCTVERSION 10 NOCACHE STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GR"
"OUPS 1))"
IMP-00003: 遇到 ORACLE 错误 922
ORA-00922: 缺少或无效选项
IMP-00017: 由于 ORACLE 的 922 错误,以下的语句失败
"CREATE TABLE "VIO_CANCEL" ("CXJDSH" VARCHAR2(10) NOT NULL ENABLE, "JDJG" VA"
"RCHAR2(10) NOT NULL ENABLE, "DSR" VARCHAR2(30), "ZSXZQH" VARCHAR2(10), "ZSX"
"XDZ" VARCHAR2(128), "CXXM" VARCHAR2(2) NOT NULL ENABLE, "JSZH" VARCHAR2(18)"
" NOT NULL ENABLE, "DABH" VARCHAR2(12) NOT NULL ENABLE, "FZJG" VARCHAR2(10),"
" "CPZL" VARCHAR2(2), "CPHM" VARCHAR2(15), "JDCSYR" VARCHAR2(128), "WFXW" VA"
"RCHAR2(4) NOT NULL ENABLE, "CXRQ" DATE NOT NULL ENABLE, "ZDBJ" VARCHAR2(1) "
"NOT NULL ENABLE, "JLLX" VARCHAR2(1) NOT NULL ENABLE, "GXSJ" DATE NOT NULL E"
"NABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 81920"
" FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "AR_USER" LOGGING NOCOMPRESS"
IMP-00003: 遇到 ORACLE 错误 922
ORA-00922: 缺少或无效选项
IMP-00017: 由于 ORACLE 的 922 错误,以下的语句失败
"CREATE TABLE "VIO_FORCE" ("PZBH" VARCHAR2(10) NOT NULL ENABLE, "XM" VARCHAR"
"2(30) NOT NULL ENABLE, "ZSXZQH" VARCHAR2(10), "ZSXXDZ" VARCHAR2(128), "TEL""
" VARCHAR2(50), "LXFS" VARCHAR2(128), "SYR" VARCHAR2(50), "JSZH" VARCHAR2(18"
"), "DABH" VARCHAR2(12) NOT NULL ENABLE, "FZJG" VARCHAR2(10) NOT NULL ENABLE"
", "HPZL" VARCHAR2(2), "PM" VARCHAR2(15), "JTFS" VARCHAR2(2) NOT NULL ENAB"
"LE, "WZSJ" DATE NOT NULL ENABLE, "WZXW1" VARCHAR2(4) NOT NULL ENABLE, "WZXW"
"2" VARCHAR2(4), "WZXW3" VARCHAR2(4), "WZXW4" VARCHAR2(4), "WZXW5" VARCHAR2("
"4), "WZDD" VARCHAR2(12) NOT NULL ENABLE, "QZCSXM" VARCHAR2(1) NOT NULL ENAB"
"LE, "KLQX" NUMBER(3, 0), "JSJQBJ" VARCHAR2(2), "ZQMJ" VARCHAR2(30) NOT NULL"
" ENABLE, "FXJG" VARCHAR2(10) NOT NULL ENABLE, "CJSJ" DATE, "JDSBH" VARCHAR2"
"(10), "CJBJ" VARCHAR2(1), "ZDBJ" VARCHAR2(1), "GXSJ" DATE, "DKBJ" VARCHAR2("
"1), "BZ" VARCHAR2(100), "LRR" VARCHAR2(30)) PCTFREE 10 PCTUSED 40 INITRANS"
" 1 MAXTRANS 255 STORAGE(INITIAL 81920 FREELISTS 1 FREELIST GROUPS 1) TABLES"
"PACE "AR_DATA" LOGGING NOCOMPRESS"
IMP-00003: 遇到 ORACLE 错误 922
ORA-00922: 缺少或无效选项
IMP-00017: 由于 ORACLE 的 922 错误,以下的语句失败
"CREATE TABLE "VIO_VIOLATION" ("WZBH" VARCHAR2(22) NOT NULL ENABLE, "JDSLB" "
"VARCHAR2(1) NOT NULL ENABLE, "DABH" VARCHAR2(12), "JDSBH" VARCHAR2(10) NOT "
"NULL ENABLE, "JSZH" VARCHAR2(18), "ZJLX" VARCHAR2(1), "FZJG" VARCHAR2(10), "
""XM" VARCHAR2(30), "XB" VARCHAR2(1), "NL" VARCHAR2(10), "ZJCX" VARCHAR2(30)"
", "ZSXZQH" VARCHAR2(10), "ZSXXDZ" VARCHAR2(128), "SYR" VARCHAR2(50), "HPZL""
" VARCHAR2(2), "PM" VARCHAR2(15), "JTFS" VARCHAR2(2) NOT NULL ENABLE, "WZS"
"J" DATE NOT NULL ENABLE, "WZDD" CHAR(12) NOT NULL ENABLE, "WZXW" CHAR(4) NO"
"T NULL ENABLE, "ZQMJ" VARCHAR2(30) NOT NULL ENABLE, "ZQMJ2" VARCHAR2(30), ""
"WZJFS" NUMBER(2, 0), "FKJE" NUMBER(6, 2), "ZNJ" NUMBER(6, 2), "JKFS" VARCHA"
"R2(1), "CLJG" VARCHAR2(10) NOT NULL ENABLE, "CFJG" VARCHAR2(4) NOT NULL ENA"
"BLE, "CLSJ" DATE, "CLBJ" VARCHAR2(1) NOT NULL ENABLE, "ZDBJ" VARCHAR2(1), ""
"GXSJ" DATE, "DKBJ" VARCHAR2(1), "TEL" VARCHAR2(50), "LXFS" VARCHAR2(128), ""
"FXJG" VARCHAR2(10) NOT NULL ENABLE, "JSJQBJ" VARCHAR2(2), "LRR" VARCHAR2(50"
") NOT NULL ENABLE, "BZ" VARCHAR2(128), "JBR1" VARCHAR2(30), "JBR2" VARCHAR2"
"(30)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 81920 "
"FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "AR_DATA" LOGGING NOCOMPRESS"
IMP-00003: 遇到 ORACLE 错误 922
ORA-00922: 缺少或无效选项
IMP-00041: 警告: 创建的对象带有编译警告
"CREATE FORCE VIEW "AR_ADMIN"."AR_FLOW_V" ("LH","XH"
"","YWLX","YWYY","SYR","HPZL","PM","CLPP1","CLXH","CLLX","XZQH","SQRQ","BJ"
"RQ","XYGW","YWLC","LSZT","GLBM","FPBJ","FFBJ","RKBJ","CLSBDH") AS "
"Select LH, Xh, Ywlx, Ywyy, Syr, Hpzl, PM, Clpp1, Clxh, Cllx, Xzqh,"
" Sqrq, Bjrq, Xygw, Ywlc, Lszt, Glbm, Fpbj, Ffbj, Rkbj, Clsbdh"
" From AR_Flow"
" Union All"
" Select LH, Xh, Ywlx, Ywyy, Syr, Hpzl, PM, Clpp1, Clxh, Cllx, Xzqh,"
" Sqrq, Bjrq, Xygw, Ywlc, Lszt, Glbm, Fpbj, Ffbj, Rkbj, Clsbdh"
" From AR_Flow_His"
IMP-00041: 警告: 创建的对象带有编译警告
"CREATE FORCE VIEW "AR_ADMIN"."AR_LOG_V" ("LH","CLR"
"Q","YWLX","YWYY","HPZL","PM","XH","YWGW","CZGW","JBR","GLBM","BZ") AS "
"Select LH, Clrq, Ywlx, Ywyy, Hpzl, PM, Xh, Ywgw, Czgw, Jbr, Glbm, Bz"
" From AR_Log"
" Union All"
" Select LH, Clrq, Ywlx, Ywyy, Hpzl, PM, Xh, Ywgw, Czgw, Jbr, Glbm, Bz"
" From AR_Log_His"
IMP-00017: 由于 ORACLE 的 2248 错误,以下的语句失败
"ALTER SESSION SET "_LOAD_WITHOUT_COMPILE" = PLSQL"
IMP-00003: 遇到 ORACLE 错误 2248
ORA-02248: 无效的 ALTER SESSION 选项
IMP-00017: 由于 ORACLE 的 1917 错误,以下的语句失败
"GRANT EXECUTE ON "AR_INTERFACE" TO "HPZY""
IMP-00003: 遇到 ORACLE 错误 1917
ORA-01917: 用户或作用'HPZY'不存在
IMP-00017: 由于 ORACLE 的 2248 错误,以下的语句失败
"ALTER SESSION SET "_LOAD_WITHOUT_COMPILE" = NONE"
IMP-00003: 遇到 ORACLE 错误 2248
ORA-02248: 无效的 ALTER SESSION 选项
IMP-00017: 由于 ORACLE 的 901 错误,以下的语句失败
"CREATE FORMAT92TRIG "
IMP-00003: 遇到 ORACLE 错误 901
ORA-00901: 无效 CREATE 命令
IMP-00008: 导出文件中出现无法识别的语句:
IMP-00008: 导出文件中出现无法识别的语句:IMP-00017: 由于 ORACLE 的 901 错误,以下的语句失败
"CREATE FORMAT92TRIG "
IMP-00003: 遇到 ORACLE 错误 901
ORA-00901: 无效 CREATE 命令
IMP-00008: 导出文件中出现无法识别的语句:
?(
IMP-00008: 导出文件中出现无法识别的语句:
IMP-00009: 导出文件异常结束
成功终止导入,但出现警告。